SQL Code

[wesleyw]

CREATE TABLE confirmations (
id int(11) NOT NULL default '0',
user_id int(11) NOT NULL default '0',
check char(32) default NULL
);


I'm creating the following table but I get Error 1064 when trying to run it what have I done wrong?


Wes

[DMcCoy]

"check" is a reserved word, use another name for the column.

[mark80]

A 1064 error according to google says that a reserve word has been used

MySQL :: MySQL 5.0 Reference Manual :: 8.3 Reserved Words

Mark

[Geoff]

 CREATE TABLE `confirmations` (
`id` INT( 11 ) NOT NULL DEFAULT '0',
`user_id` INT( 11 ) NOT NULL DEFAULT '0',
`check` CHAR( 32 ) NULL DEFAULT NULL
) ENGINE = MYISAM