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 ><< > ># 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 '', >KEY a1 (a1), >KEY a2 (a2), >KEY a3 (a3), >KEY a4 (a4) >) TYPE=MyISAM; ><< > ># How insert into table <- text columns with indexes: (1, 2, 3, 5) ?????? ># How ignore text columns with indexes (4, 6) ??? >mysql>> LOAD DATA LOCAL INFILE 't.txt' INTO TABLE userdata FIELDS >mysql>> TERMINATED BY ',' ENCLOSED BY '"' (a1, a2, a3, a4); > > ># If need to have this rezult: >mysql> select * from userdata; >+-----+-----+-----+-----+ >| a1 | a2 | a3 | a4 | >+-----+-----+-----+-----+ >| 111 | 222 | 333 | 444 | >| 111 | 222 | 333 | 444 | >| 111 | 222 | 333 | 444 | >+-----+-----+-----+-----+ > > >Thanks Very much. > >Alvydas > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
