Re: LOAD - updates?

2008-10-16 Thread Perrin Harkins
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 erro

LOAD - updates?

2008-10-16 Thread Reyna.Sabina
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'