All pastes #929897 Raw Edit

Miscellany

public text v1 · immutable
·published 2008-03-06 03:11 UTC
rendered paste body
mysql> db_query("CREATE TABLE IF NOT EXISTS {signup_status_codes} (
    "> cid int unsigned NOT NULL auto_increment,
    "> name varchar(128) NOT NULL default '',
    "> description text NOT NULL,
    "> mod_signup_count int NOT NULL default 0,
    "> auto_transition int NOT NULL default 0,
    "> show_on_form int NOT NULL default 0,
    "> PRIMARY KEY (cid),
    "> UNIQUE KEY name (name)
    "> ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
ERROR 1064 (42000): 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 'db_qu
ery("CREATE TABLE IF NOT EXISTS {signup_status_codes} (
cid int unsigned NO' at line 1
mysql>