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

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

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

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

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

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

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

タイトル