Running SQL query, but errors...

[RdP666]

I run the following SQL query in PHPMyAdmin:

CREATE TABLE message (
id int(11) NOT NULL auto_increment,
read char(3) NOT NULL default '',
show char(3) NOT NULL default '',
from varchar(50) NOT NULL default '',
to varchar(50) NOT NULL default '',
subject varchar(50) NOT NULL default '',
msg tinytext NOT NULL,
time timestamp(14) NOT NULL,
readconfirm char(3) NOT NULL default '',
sr char(1) NOT NULL default '',
linkid varchar(32) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) TYPE=MyISAM;

This is what I get back: You have an error in your SQL syntax near 'read char(3) NOT NULL default '', SHOW char(3) NOT NULL default '', FROM varchar' at line 1

:confused:

[Spookster]

You have at least 3 columns names that are reserved words in MySQL.

http://www.mysql.com/doc/en/Reserved_words.html