Be struggling with this all day, try to figure out why when using the 'load data infile..' all it loads is the first line for the text file and that's it!
Table structure: CREATE TABLE `retailtag` ( `prodid` smallint(4) NOT NULL default '0', `tagnumber` varchar(10) NOT NULL default '', `code` varchar(10) NOT NULL default '', UNIQUE KEY `tagnumber` (`tagnumber`,`code`), KEY `prodid` (`prodid`) ) TYPE=MyISAM; QUERY: $mysql> load data local infile '/home/tracerta/tmp/retailtag.txt' into table retailtag fields terminated by '|' lines terminated by '\n'; the text file is contructed as such: ID|NUM|CODE ID|NUM|CODE ID|NUM|CODE ....etc approx., 1600 records But it only grabs the file line, and stops. I've tried it with a CSV format, and TAB format, still the same thing, grabs the first line, and that's it?? is the file in the wrong format?? thx's mysql database sql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- 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
