Re: LOAD - updates?
On Thu, Oct 16, 2008 at 3:40 PM, Reyna.Sabina <[EMAIL PROTECTED]> wrote: > 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. Do you mean LOAD DATA INFILE? It will give an error unless you specify IGNORE or ON DUPLICATE UPDATE. The documentation explains this in detail. > LOAD acted as an UPDATE statement and it didn't give > an error - the return status was 0. Then you probably used the ON DUPLICATE UPDATE clause. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD - updates?
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/PHODFax: (305) 361-4392 4301 Rickenbacker CausewayEmail: [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]
