MySQL Forums
Forum List  »  MySQL Workbench

Re: Error to create a table with workbench
Posted by: Mike Lischke
Date: September 21, 2009 12:09AM

Abraham,

the error message seems to say exactly what is wrong. Why don't you fix the line:

`intFechaAlta` INT NOT NULL DEFAULT today COMMENT 'Poner la fecha de su alta a GlobalMx' ,

?

"today" is not a valid default value for an integer column (or any other type). If you want a timestamp column which receives the time a certain record was inserted use a TIMESTAMP column with a default of CURRENT_TIMESTAMP.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
3757
September 18, 2009 11:12PM
Re: Error to create a table with workbench
1974
September 21, 2009 12:09AM


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.