I am trying to create a table in
MySQL but I keep getting an error of incorrect syntax. Below is my create table syntax, what is incorrect?
CREATE TABLE [Test].[dbo].[Ite]( [ID] [INT] NOT NULL AUTO_INCREMENT, [ite] [varchar](500) NULL, [dollarvalue] DECIMAL(10,2) NULL)
Here is exact error message
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 '[Test].[dbo].[Ite]( [ID] [INT] NOT NULL AUTO_INCREMENT, [i' at line 1