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't

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 error