handling mysql constraint errors

Question

I tried searching for a solution in this website but I can't seem to find any.

I needed to find a way to know which field in my table is causing the constraint error.. In my table, say members table two fields (username,email) are unique keys and defined as unique keys apart from my primary key (memberid). When i add data to this table for a similar user and/or email address this error occurs:

"duplicate entry '[email protected]' for key2"

i want to tell the user which field is causing duplicate entry so as to say "that email is already registered"

I cannot seem to find a mysql function to loop through error keys upon insert...

This is why I don't usually like using constraints in MySQL. I mean, your app has to know about them, anyway. — staticsan
– staticsan, Commented Nov 9, 2009 at 1:54

Don · Accepted Answer · 2009-11-09 01:53:10Z

2

On my sites, I actually check the unique fields myself with Select 1 from tab where field = 'value' limit 1; just so that I can give nice error messages instead of encountering an exception coming back from my insert statement.

answered Nov 9, 2009 at 1:53

Don

4,6832 gold badges29 silver badges32 bronze badges

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

Comments

jan · Accepted Answer · 2009-11-09 05:37:35Z

0

i guess naming constraint fields is not yet a feature in mysql. hope they consider this as this is very useful and saves a lot of code times and lines.

answered Nov 9, 2009 at 5:37

jan

952 silver badges10 bronze badges

Collectives™ on Stack Overflow

handling mysql constraint 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