Re: Problem Importing Data from Text File, HOW IGNORE SOME TEXT COLUMNS???

Reformat your import file. or Add two columns , import, and drop the two columns. or Import to a six column temporary file and do an insert into select from. tl wrote: >Hello, > >#If I have a file "t.txt" > > >111 222 333 ddd 444 ddd >111 222 333 ddd 444 ddd >111 222 333 ddd 444 ddd ><< >

Problem Importing Data from Text File, HOW IGNORE SOME TEXT COLUMNS???

Hello, #If I have a file "t.txt" >> 111 222 333 ddd 444 ddd 111 222 333 ddd 444 ddd 111 222 333 ddd 444 ddd << # A table >> CREATE TABLE userdata ( a1 varchar(128) NOT NULL default '', a2 varchar(128) NOT NULL default '', a3 varchar(128) NOT NULL default '', a4 varchar(128) NOT NULL default '',