Return
-
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`) )' "
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.