tag:blogger.com,1999:blog-15319370.post114517722051933908..comments2024-03-05T11:16:00.846+01:00Comments on Roland Bouman's blog: Overview of Server SQL Modesrpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-15319370.post-1145480593622545282006-04-19T23:03:00.000+02:002006-04-19T23:03:00.000+02:00Richard, glad you like it! I will be maintaining t...Richard, <BR/><BR/>glad you like it! I will be maintaining this chart in the wiki of MySQLForge. You can find it <A HREF="http://forge.mysql.com/wiki/Server_SQL_Mode_Quickref" REL="nofollow">here</A>.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1145438617891456512006-04-19T11:23:00.000+02:002006-04-19T11:23:00.000+02:00OK, ignore that last one I've just found the answe...OK, ignore that last one I've just found the answer in another part of the relevant documentation ...<BR/><BR/>"Make MySQL behave like a “traditional” SQL database system. A simple description of this mode is “give an error instead of a warning” when inserting an incorrect value into a column. Note: The INSERT/UPDATE aborts as soon as the error is noticed. This may not be what you want if you are using a non-transactional storage engine, because data changes made prior to the error are not be rolled back, resulting in a “partially done” update. (Added in MySQL 5.0.2)"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1145438442248483982006-04-19T11:20:00.000+02:002006-04-19T11:20:00.000+02:00Thanks for this it certainly makes it easier to un...Thanks for this it certainly makes it easier to understand than the MySQL documentation. I've got a question - what does 'TRADITIONAL' mean though ? The documentation doesn't make it very clear - do you know ?Anonymousnoreply@blogger.com