Is this a correct querri? [Archive]

RichieBoy67

03-02-2005, 08:56 PM

I keep getting a syntax error..

CREATE TABLE '. TABLE_PREFIX .'vb_jukebox_trax (
`songid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '\',
`url` varchar(100) NOT NULL default \'\',
`plays` smallint(5) default \'0\',
`active` int(2) NOT NULL default \'0\',
`userid` int(11) NOT NULL default \'0\',
`username` varchar(225) NOT NULL default \'\',
`rated_qty` int(5) NOT NULL default \'0\',
`rating` int(5) NOT NULL default \'0\',
`announce` int(2) NOT NULL default \'0\',
`genre` varchar(50) NOT NULL default \'\',
PRIMARY KEY (`songid`)

Paul M

03-02-2005, 09:39 PM

Well at first glance it looks like a missing \ on the "title" line - after the word "default".

Zachery

03-02-2005, 09:40 PM

I keep getting a syntax error..

CREATE TABLE '. TABLE_PREFIX .'vb_jukebox_trax (
`songid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '\',
`url` varchar(100) NOT NULL default \'\',
`plays` smallint(5) default \'0\',
`active` int(2) NOT NULL default \'0\',
`userid` int(11) NOT NULL default \'0\',
`username` varchar(225) NOT NULL default \'\',
`rated_qty` int(5) NOT NULL default \'0\',
`rating` int(5) NOT NULL default \'0\',
`announce` int(2) NOT NULL default \'0\',
`genre` varchar(50) NOT NULL default \'\',
PRIMARY KEY (`songid`)
Well thats not a syntax error, thats a query.

Whats the error, and what are you trying to run it in

RichieBoy67

03-02-2005, 09:55 PM

Forget it. I figured it out... Thanks

Sorry, I didn't post the error but it said syntax so I figured that I did something wrong with the query. This is fixed now... now I just need to find out what else is wrong...lol

-

Paul M

03-03-2005, 08:12 AM

Well how about telling us what was wrong then .....

RichieBoy67

03-03-2005, 11:16 PM

I did it the easy was and added it directly so I didn't need to do query.... MYSQL is not my thing at all...

--