How to disable MySQL's errors?

Question

I have a table in my database with a string for a primary_key, which I set. I need to check frequently if around 1000 "items" exist in that table before adding them, because there must not be any duplicates. The result is 2 queries per Item, or 2000 total, which is 1-2 seconds of extra loading time.

If I try to insert the new row anyway, without checking for duplicates it doesn't get inserted and that's great, but mysql returns an error, which crashes my service.

My questions:

Can I turn off those errors?
Is there a better way to prevent inserting duplicates than making an extra query?

If the service is crashing then your code needs fixing! so yes something else does need fixing don't ignore errors fix them. — Dave
– Dave, Commented Jun 18, 2013 at 12:20
If you have a solution, post your answer. I can think of "fix the error" myself. — Nikolay Dyankov
– Nikolay Dyankov, Commented Jun 18, 2013 at 12:22

Sirko · Accepted Answer · 2013-06-18 12:17:37Z

5

You could use the IGNORE keyword to have duplicates dropped from your inserts:

INSERT IGNORE INTO yourTable Values (...)

answered Jun 18, 2013 at 12:17

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

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

Comments

Your Common Sense · Accepted Answer · 2013-06-18 12:17:28Z

5

mysql returns an error, which crashes my service.

it's actually your own code that crashes your service as mysql error cannot crash anything.

Is there a better way to prevent inserting duplicates

INSERT IGNORE

answered Jun 18, 2013 at 12:17

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Collectives™ on Stack Overflow

How to disable MySQL's errors?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related