wreck
08-06-2004, 11:17 AM
this is the error i get trying to run it... the other 2 querys for it run perfectly fine no problems, but this one wont... anybody got any idea why it wont work? this is what the error says
Database mvzsvhjf_forums running on localhost
Error
SQL-query :
CREATE TABLE toplist_settings(
settingid int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
title varchar( 50 ) NOT NULL default '',
value varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( settingid )
) INSERT INTO toplist_settings
VALUES (
'1', 'lastreset', '20020402'
)
MySQL said:
#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 'INSERT INTO toplist_settings VALUES('1','lastreset','20020402')
Database mvzsvhjf_forums running on localhost
Error
SQL-query :
CREATE TABLE toplist_settings(
settingid int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
title varchar( 50 ) NOT NULL default '',
value varchar( 20 ) NOT NULL default '',
PRIMARY KEY ( settingid )
) INSERT INTO toplist_settings
VALUES (
'1', 'lastreset', '20020402'
)
MySQL said:
#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 'INSERT INTO toplist_settings VALUES('1','lastreset','20020402')