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]
