Microsoft SQL Server Management Studio query to MySQLWorkbench

[Leon Sharkoon]

Hi

Just trying to create some new tables. I've tested them already in office, and want them now in MySQLWorkbench too.
That's the query, which I exported from MS SQL Studio:



USE [SAM_PLAYGROUND_LOCAL]
GO

/****** Object: Table [dbo].[RSS_FEEDS] Script Date: 12/19/2012 17:26:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[RSS_FEEDS](
[RSSID] [int] IDENTITY(1,1) NOT NULL,
[Provider] [varchar](50) NULL,
[FeedName] [varchar](100) NULL,
[varchar](1000) NULL, [Language] [varchar](2) NULL, [dt_insert] [datetime] NOT NULL, [dt_remove] [datetime] NULL, [Frequency] [int] NULL, [dt_lastUpdate] [datetime] NULL, CONSTRAINT [PK_RSS FEEDS] PRIMARY KEY CLUSTERED ( [RSSID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[RSS_FEEDS] ADD CONSTRAINT [DF_RSS FEEDS_dt_insert] DEFAULT (getdate()) FOR [dt_insert] GO //-------------------------// Thats the error I get: 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 '[SAM_PLAYGROUND_LOCAL] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SE' at line 1 //-------------------------// What's wrong with my query? Sorry for the bad format, but I don't know how to handle it right :D Thank you all! //-------------------------// Regards Leon Edited 4 time(s). Last edit at 12/19/2012 02:08PM by Leon Sharkoon.