This is from the manual. See the 3rd paragraph. > The REPLACE and IGNORE keywords control handling of input records that duplicate > existing records on unique key values. > > If you specify REPLACE, input rows replace existing rows (in other words rows that > has the same value for a primary or unique index as an existing row). See section > 6.4.7 REPLACE Syntax. > > If you specify IGNORE, input rows that duplicate an existing row on a unique key > value are skipped. If you don't specify either option, the behavior depends on > whether or not the LOCAL keyword is specified. Without LOCAL, an error occurs when a > duplicate key value is found, and the rest of the text file is ignored. With LOCAL, > the default behavior is the same as if IGNORE is specified; this is because the > server has no way to stop transmission of the file in the middle of the operation.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]