gistfile1.sql

create table names_table (
  first_name varchar(20), 
  last_name varchar(20), 
  birth_date date);

load data infile '/tmp/anu/20120219' 
into table names_table 
fields terminated by '\t' 
lines terminated by '\n' 
(first_name, last_name, @var1) 
set birth_date = str_to_date(@var1, '%d-%b-%y');