Re: skip duplicate entries

[Nick Roper]

krazy,

short answer - yes

longer answer - it depends on the import method you use and how you have indexes configured. For example, here is an extract from the on-line reference:

" ... If you specify the IGNORE keyword in an INSERT with many rows, any rows that duplicate an existing UNIQUE index or PRIMARY KEY value in the table are ignored and are not inserted. If you do not specify IGNORE, the insert is aborted if there is any row that duplicates an existing key value. You can determine with the mysql_info() C API function how many row's were inserted into the table..."

Full details at: http://dev.mysql.com/doc/mysql/en/INSERT.html

If you are loading data from a delimited text file - rather than executing multiple INSERT statements, the you can use the LOAD DATA INFILE statement, which also has options to ignore duplicates, see:

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html

Hope this helps,

Nick

--
Nick Roper