How MySQL Deals with Constraints??

MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. Because of this, constraint handling is a bit different in MySQL than in other DBMSs. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs.
The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the statement. We do this in most cases, but not yet for all.
The options MySQL has when an error occurs are to stop the statement in the middle or to recover as well as possible from the problem and continue. By default, the server follows the latter course. This means, for example, that the server may coerce illegal values to the closest legal values.

• www.fuvision.com
• www.fucraft.com
&bul
l; www.fuanimedia.com
•
• Contact for more information: 9003206648
•
•
• Coimbatore Address:
• No: 96,Hope College bus stop,
• Opp Krishna sweets, Peelamedu,
• Avinashi road, Coimbatore.
•
• Madurai Address:
• near BELL Hotel,
• Rajan Complex – 3rd floor
• Tamil Sangam Road,