- MySQL Error
- Message: MySQL Query Error
- SQL: UPDATE uchome_plug_newfarm set fb=fb+ where uid=1
- Error: 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 'where uid=1' at line 1
- Errno.: 1064
- Click here to seek help.
复制代码建表
CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint(8) NOT NULL,
`farmlandstatus` text character set utf8 NOT NULL,
`animal` text character set utf8 NOT NULL,
`taskid` int(2) NOT NULL default '1',
`charm` int(10) NOT NULL default '0',
`money` int(10) NOT NULL default '0',
`exp` int(10) NOT NULL default '0',
`mc_exp` int(10) NOT NULL default '0',
`fb` int(10) NOT NULL default '0',
`reclaim` smallint(2) NOT NULL default '6',
`package` text character set utf8 NOT NULL,
`mc_package` text character set utf8 NOT NULL,
`fertilizer` text character set utf8 NOT NULL,
`decorative` text character set utf8 NOT NULL,
`fruit` text character set utf8 NOT NULL,
`dog` text character set utf8 NOT NULL,
`nosegay` text character set utf8 NOT NULL,
`message` text character set utf8 NOT NULL,
`mc_taskid` int(2) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
这个怎么建呀 |