Stupid problem this one no doubt. I have a find in mysql\bin called words.txt
The file contains tab separated values with a newline character at the end: 225 20 Residence 73.5 63.5 80 187.5 225 20 Planibel 195.5 63.5 79.5 289 When I do LOAD DATA LOCAL INFILE "words.txt" INTO TABLE tblftpagewordpos I get lots of warnings and when I query the table, the values are all zeros (when I have a default value set) I am no doubt doing something stupid, but it is doing my head in now. Any help really appreciated. Many thanks John. --------------------------------------------------------------------- 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
