Ignore mysql error messages when executing an sql file

Question

I am copying records from one table to another and there is a chance that some records may already be in the second table i am copying the records to.

Since there are lots of rows i am copying,i am looking a way to ignore all the record already exists messages from mysql and continue executing the mysql file.

Is there a way i can suppress the error messages?.

I dont want to insert duplicate records.

You Know Nothing Jon Snow
– You Know Nothing Jon Snow

2013-07-15 14:44:09 +00:00
Commented Jul 15, 2013 at 14:44 — You Know Nothing Jon Snow
– You Know Nothing Jon Snow, Commented Jul 15, 2013 at 14:44

eggyal · Accepted Answer · 2013-07-15 14:44:30Z

4

As documented under INSERT Syntax:

The INSERT statement supports the following modifiers:
[ deletia ]
If you use the IGNORE keyword, errors that occur while executing the INSERT statement are treated as warnings instead. For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row still is not inserted, but no error is issued.

answered Jul 15, 2013 at 14:44

eggyal

127k18 gold badges220 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

eggyal Over a year ago

See also “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”

develCuy · Accepted Answer · 2014-08-30 05:52:12Z

0

Try this:

zcat db.sql.gz | sed -e 's/INSERT/INSERT IGNORE/' | mysql -u user -p dbname

answered Aug 30, 2014 at 5:52

develCuy

6557 silver badges14 bronze badges

Collectives™ on Stack Overflow

Ignore mysql error messages when executing an sql file

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related