MySQL Forums
Forum List  »  InnoDB

Re: Invalid default value
Posted by: Peter Brawley
Date: August 14, 2014 11:31AM

> on one system wehere the CREATE TABLE failed, it was reported that removing STRICT_TRANS_TABLES from sql-mode fixed the problem.

What was the whole sql_mode setting?

Options: ReplyQuote


Subject
Views
Written By
Posted
2841
August 13, 2014 12:34PM
994
August 13, 2014 12:40PM
1667
August 13, 2014 01:01PM
1318
August 13, 2014 02:12PM
Re: Invalid default value
871
August 14, 2014 11:31AM
925
August 14, 2014 12:29PM
924
August 14, 2014 02:43PM
845
August 15, 2014 09:58PM
1416
August 15, 2014 10:39PM
889
August 16, 2014 05:15AM
979
August 16, 2014 07:56AM
863
August 16, 2014 05:18AM


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.