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
