Whats wrong with this?

[roldahayes]

Create Table PageType (
   TypeID int identity primary key,
   TypeDesc varChar(max)
)

Create Table Quotes (
   QuoteID int identity primary key,
   PageTypeID int not null foreign key references PageType,
   Quote nVarChar(max),
   Author nVarChar(300)
)

 

get this error...

 

#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 'identity primary key,
   TypeDesc varChar(max)
)

Create Table Quotes (
   ' at line 2 

[Barand]

That is MS-SQL code, not MySQL