Script generated for table with an Identity column with auto_increment fails with "You have an error in your SQL syntax" when executed (4309351)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Script generated for table with an Identity column with auto_increment fails with "You have an error in your SQL syntax" when executed
Description

The following error occurs when executing a MySQL 5.5 DDL script that was generated in Toad Data Modeler:
CREATE TABLE `Test` ( `TestId` Bigint UNSIGNED NOT NULL AUTO_INCREMENT,`TestTypeId` Int)
"Error Code: 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 '`TestId` (`TestId`) )' "
Cause

Auto Increment clause for the primary key needs to be part of the Create Table script, rather than generated as an Alter Table.
Resolution

WORKAROUND
Change the generate script options as follows:

STATUS
Fixed in version 6.2. The latest release can be downloaded here.
Defect ID

TDM-3000

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title