PDA

View Full Version : sql error, please help


twistedrhymes
12.07.2004, 13:57
this is my first component..
didn't think i'd upload and work fine, but i'm stuck on this... can't figure out what is wrong with it! any suggestions? TINYINT(1) is used in another table that loads fine..


SQL Error DB function failed with error number 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 'shot` TINYINT(1) NOT NULL, `wtf` TINYINT(1) NOT NULL, `co SQL=CREATE TABLE `mos_mv_nightsconfig` ( `bold` TINYINT(1) NOT NULL, `italic' TINYINT(1) NOT NULL, `shot` TINYINT(1) NOT NULL, `wtf` TINYINT(1) NOT NULL, `configid` TINYINT(4) NOT NULL, PRIMARY KEY(`configid`) )
SQL =
CREATE TABLE `mos_mv_nightsconfig` (
`bold` TINYINT(1) NOT NULL,
`italic' TINYINT(1) NOT NULL,
`shot` TINYINT(1) NOT NULL,
`wtf` TINYINT(1) NOT NULL,
`configid` TINYINT(4) NOT NULL,
PRIMARY KEY(`configid`)
)

twistedrhymes
12.07.2004, 14:14
:) found the problem...
for all you newbies out there (like me)
you must use ` to close in variable names and not '