Guaranteeing Data Integrity with MySQL 5.0

A new poll running on the MySQL web site shows that a lot of folks still aren't familiar with the strict mode/sql mode setting that was introduced with MySQL 5.0. The sql_mode parameter allows you to have MySQL better enforce data integrity in terms of what data is accepted/rejected by the server. Not having this capability produced a number of gotchas in previous MySQL versions, but in 5.0, these all go away.

Full Article by Robin Schumacher:
http://dev.mysql.com/tech-resources/articles/mysql-data-integrity.html

• Slashdot it!
• Digg it:
  
• Del.icio.us