MySQL Forums
Forum List  »  InnoDB

what exactly does Traditional MODE
Posted by: Frens Dols
Date: September 09, 2008 06:43AM

TRADITIONAL MODE is defined as (http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html):
TRADITIONAL
Equivalent to STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER.

For STRICT_ALL_TABLES, MySQL returns an error and ignores the rest of the rows.

For STRICT_TRANS_TABLES, MySQL converts an invalid value to the closest valid value for the column and insert the adjusted value.

QUESTION: Since TRADITIONAL MODE contains both strict_all_tables and strict_transtables, what does TRADITIONAL MODE do with a a simple local databse in case an invalid value is inserted?

I do not know since these two included options seem to contradict each other.

Options: ReplyQuote


Subject
Views
Written By
Posted
what exactly does Traditional MODE
5766
September 09, 2008 06:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.