Click here to Skip to main content
11,584,455 members (65,606 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Stored procedure
I have created simple stored procedure to insert values to table, If i try to insert duplicate value it has to show the error, but it not showing error, it showing executed succesfully, but when see the table that duplicate value not inserted. How i handle these errors.
Posted 30-Apr-12 0:59am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Please refer this article Error-Handling[^] in MySQL.
Hope you get some help.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 430
1 Sergey Alexandrovich Kryukov 369
2 Dave Kreskowiak 260
3 Richard Deeming 220
4 virusstorm 194
0 OriginalGriff 1,663
1 Sergey Alexandrovich Kryukov 1,229
2 Abhinav S 701
3 Dave Kreskowiak 667
4 Suvendu Shekhar Giri 568


Advertise | Privacy | Mobile
Web03 | 2.8.150603.1 | Last Updated 30 Apr 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100