Help please
Fel
SQL-fråga:
CREATE TABLE `z_shop_offer` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`points` int( 11 ) NOT NULL default '0',
`itemid1` int( 11 ) NOT NULL default '0',
`count1` int( 11 ) NOT NULL default '0',
`itemid2` int( 11 ) NOT NULL default '0',
`count2` int( 11 ) NOT NULL default '0',
`offer_type` varchar( 255 ) default NULL ,
`offer_description` text NOT NULL ,
`offer_name` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';
MySQL sa:
#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 'ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0'' at line 14
Fel
SQL-fråga:
CREATE TABLE `z_shop_offer` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`points` int( 11 ) NOT NULL default '0',
`itemid1` int( 11 ) NOT NULL default '0',
`count1` int( 11 ) NOT NULL default '0',
`itemid2` int( 11 ) NOT NULL default '0',
`count2` int( 11 ) NOT NULL default '0',
`offer_type` varchar( 255 ) default NULL ,
`offer_description` text NOT NULL ,
`offer_name` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';
MySQL sa:
#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 'ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0'' at line 14