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