Skip navigation links

MySQL Forums :: MySQL Workbench :: Forward Engineering Data Modeling Design Causes Error


Advanced Search

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

ENGINE = InnoDB;


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


Subject Views Written By Posted
Forward Engineering Data Modeling Design Causes Error 1009 Russell Simmons 04/16/2012 01:24PM
Re: Forward Engineering Data Modeling Design Causes Error 434 Rick James 04/18/2012 10:12AM
Re: Forward Engineering Data Modeling Design Causes Error 377 Russell Simmons 04/18/2012 10:28AM
Re: Forward Engineering Data Modeling Design Causes Error 498 Mike Lischke 04/20/2012 02: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.