Log in or Sign up

Why we use STRICT_ALL_TABLES AND STRICT_TRANS_TABLES?

Discussion in 'MySQL' started by jasonmark, Jan 24, 2011.

jasonmark Peon

Messages:

29

Likes Received:

0

Best Answers:

0

Trophy Points:

0

#1

Please explain this why we use this.

jasonmark, Jan 24, 2011 IP
mysqlxpert Greenhorn

Messages:

30

Likes Received:

0

Best Answers:

0

Trophy Points:

16

#2

MySQL Manual said:

Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no explicit DEFAULT clause in its definition. (For a NULL column, NULL is inserted if the value is missing.)
Click to expand...

Checkout mysql manual (http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html#sqlmode_strict_all_tables)

mysqlxpert, Jan 24, 2011 IP

(You must log in or sign up to reply here.)