Commiting Schemas to DB error
I'm new to MySQL (and databases in general). I tried creating a few tables in a new schema using MySQL Workbench. I attempted to "Synchronize Model with Database" but it completed with errors. I checked in MySQLWorkbench-->MySQL tab-->Navigator.Schemas (refreshed the view), and only ONE of the tables I created appears there (tblComtemporaryrates).
I am using MySQL 5.7.16 Win64.
MySQL Workbench: 6.3.7 (build 1199CE)
Can anyone please lead me in the right direction? I came from Access as a novice and this system is very different.
The error was....
-------------------------------------------------------------------------
Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` NULL)
ENGINE = InnoDB
DEFAULT C' at line 2
SQL Code:
CREATE TABLE IF NOT EXISTS `mydb`.`timestamps` (
`create_time` NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` NULL)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
SQL script execution finished: statements: 3 succeeded, 1 failed
Fetching back view definitions in final form.
Nothing to fetch
Subject
Views
Written By
Posted
Commiting Schemas to DB error
1721
November 06, 2016 01:27PM
572
November 06, 2016 03:02PM
515
November 06, 2016 04:59PM
548
November 06, 2016 06:52PM
1064
November 08, 2016 06:55AM
638
November 09, 2016 02:19AM
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.