Check the manual.
"Type" is a reserved word.
"Date" is a reserved word.
Martin wrote:
The following CREATE TABLE came from a mysqldump. When I use the same create
statement to create the table under mysql 3.23 I get an error:
# MySQL dump 8.12
#
# Host: localhostDatabase: installers
Gerald L. Clark" [EMAIL PROTECTED]
To: "Martin" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 1:23
Subject: Re: CREATE from a mysqldump won't CREATE a table in 3.23?
Check the manual.
"Type" is a reserved word.
"Date" is a reserved word.
The following CREATE TABLE came from a mysqldump. When I use the same create
statement to create the table under mysql 3.23 I get an error:
# MySQL dump 8.12
#
# Host: localhostDatabase: installers
#
# Server version3.23.32-log