gistfile1.sql

create table names_table (
  first_name varchar(20), 
  last_name varchar(20), 
  city varchar(20));

load data infile '/tmp/anu/20120219' 
into table names_table 
fields terminated by '\t' 
lines terminated by '\n' 
(first_name, last_name) 
set city='Bangalore';