MySQL Forums
Forum List  »  MySQL Workbench

Forward Engineering Data Modeling Design Causes Error
Posted by: Russell Simmons
Date: April 16, 2012 01:24PM

I'm using Workbench 5.3.28 to design a database. However, when I try to forward engineer, I get an error.

The SQL script that's causing the error is:

-- -----------------------------------------------------

-- Table `mydb`.`Training_Classes`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `mydb`.`Training_Classes` (

`Training_Key` CHAR(10) NOT NULL COMMENT 'This is the course number (i.e. IS-100, AWR-177)' ,

`Expiration_Term` TINYINT ZEROFILL NOT NULL COMMENT 'The training expiration time, in months. If the training doesn\'t expire, then 0.' ,

`Training_Desc` VARCHAR(45) NOT NULL ,

INDEX `Training_Key` () ,

PRIMARY KEY (`Training_Key`) ,

UNIQUE INDEX `Training_Key_UNIQUE` (`Training_Key` ASC) )


The error says:

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 ') ,

PRIMARY KEY (`Training_Key`) ,

UNIQUE INDEX `Training_Key_UNIQUE` (`Trai' at line 8

I'm familiar with database design, but not so much with MyQSL.

Does anyone have an idea what I'm doing wrong?

Options: ReplyQuote

Written By
Forward Engineering Data Modeling Design Causes Error
April 16, 2012 01:24PM

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.