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

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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`) )' "
Ursache

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

WORKAROUND
Change the generate script options as follows:

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

TDM-3000

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel