In the last episode (Jul 29), Prince Chidi Ajuzie said: > MySQL Question > I run sql version 3.23.42. > > LOAD DATA INFILE "/usr/lists" INTO TABLE lists; > ERROR 1062: Duplicate entry '1' for key 1 > > Please how do i run this successfully. Ive tried the REPLACE option without > any luck.
You probably have a TINYINT AUTOINCREMENT field, which means you can only have 127 rows in your table. Make it an INT or BIGINT. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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