MySQL Forums
Forum List  »  MySQL Workbench

Commiting Schemas to DB error
Posted by: Menoo Trogdor
Date: November 06, 2016 01:27PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Commiting Schemas to DB error
1563
November 06, 2016 01:27PM
509
November 06, 2016 03:02PM
446
November 06, 2016 04:59PM
470
November 06, 2016 06:52PM
985
November 08, 2016 06:55AM
560
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.