I have a SQL file that I generated on MS SQL 7. The file looks like this (a portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[AuthorID] [int] NOT NULL ,
[Date] [datetime] NOT NULL ,
[SubjectID] [int] NOT NULL ,
[Pages] [int] NOT NULL ,
[Image] [text] NOT NULL ,
[ManuID] [int] NULL ,
[Publish] [char] (10) NULL ,
[BuyText] [char] (100) NULL ,
[BuyLink] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[Authors] (
[AuthorID] [int] IDENTITY (1, 1) NOT NULL ,
[AuthorName] [char] (50) NOT NULL ,
[AuthorEmail] [char] (50) NOT NULL
) ON [PRIMARY]
GO
I am using phpMyAdmin and attempting to run the SQL query on the database that has
already been created. I get the error: MySQL said: You have an error in your SQL
syntax near '[dbo].[Articles] ( [ArticleID] [int] IDENTITY (1, 1) NOT NULL , [Title]
[cha' at line 1
What is the syntax problem that I am missing? And can I make MS SQL output the sql
file in the correct way?
Ryan Shrout
Athlonmb.com
Production Manager
http://www.athlonmb.com/
[EMAIL PROTECTED]
