Hello, Running Environment: MySQL Server version: 5.0.45 OS is Red-Hat 64-bit
A test using mysql -e "LOAD table ..." was ran to see if "LOAD' will give an error when loading a record with the same primary-key of an existing record in the table. LOAD acted as an UPDATE statement and it didn't give an error - the return status was 0. Is this the correct LOAD behaviour? Thanks in advance for your input! Reyna _________________________________________________________ Reyna Sabina Phone: (305) 361-4324 NOAA/AOML/PHOD Fax: (305) 361-4392 4301 Rickenbacker Causeway Email: [EMAIL PROTECTED] Miami, FL 33149-1087 "Things do not get better by being left alone." -Winston Churchill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]