diff options
author | Bibiko <bibiko@eva.mpg.de> | 2010-03-06 14:42:51 +0000 |
---|---|---|
committer | Bibiko <bibiko@eva.mpg.de> | 2010-03-06 14:42:51 +0000 |
commit | ecbc556ad0ed6e6c66c76145085a524bf8d6035d (patch) | |
tree | 54f4c7513026113ab0baef757e0983325eb66f2e /Source/CMCopyTable.h | |
parent | 54da3a6b973deb893ce9c8d094ce37ef4c66f9d6 (diff) | |
download | sequelpro-ecbc556ad0ed6e6c66c76145085a524bf8d6035d.tar.gz sequelpro-ecbc556ad0ed6e6c66c76145085a524bf8d6035d.tar.bz2 sequelpro-ecbc556ad0ed6e6c66c76145085a524bf8d6035d.zip |
• CSV Import Field Mapper
- added to INSERT advanced option "Skip existing rows"
This option allows to insert only those source file rows which primary keys do not exist. It executes INSERT INTO … ON DUPLICATE KEY UPDATE `pri_key_name` = `pri_key_name`. This statement suppresses all warnings/errors regarding to duplicates pri keys etc. BUT it gives an error if an INSERT… statement of a remaining row was erroneous.
Diffstat (limited to 'Source/CMCopyTable.h')
0 files changed, 0 insertions, 0 deletions