error

ik kreeg een error bij deze table:


CREATE TABLE `weapons` (
`pistol` varchar(20) NOT NULL default `1`,
`.22 rifle` varchar(20) NOT NULL default `2`,
`Browning` varchar(20) NOT NULL default `3`,
`M16` varchar(20) NOT NULL default `4`,
`Desert Eagle` varchar(20) NOT NULL default `6`,
};




dit is de error:

SQL-query:

CREATE TABLE `weapons` (

`pistol` varchar( 20 ) NOT NULL default `1` ,
`.22 rifle` varchar( 20 ) NOT NULL default `2` ,
`Browning` varchar( 20 ) NOT NULL default `3` ,
`M16` varchar( 20 ) NOT NULL default `4` ,
`Desert Eagle` varchar( 20 ) NOT NULL default `6` ,
}

MySQL retourneerde:

#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 '1`,
`.22 rifle` varchar(20) NOT NULL default `2`,
`Browning`