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 'collate gb2312_bin NOT NULL default '', `sex` varchar(10) NOT
CREATE TABLE `mv_admin` ( `id` int(10) NOT NULL auto_increment, `cs` varchar(30) NOT NULL default '', `password` varchar(32) NOT NULL default '', `username` varchar(30) character set gb2312 collate gb2312_bin NOT NULL default '', `sex` varchar(10) NOT NULL default '', `qq` varchar(20) NOT NULL default '', `msn` varchar(200) NOT NULL default '', `email` varchar(255) NOT NULL default '', `tel` varchar(30) NOT NULL default '', `mobile` varchar(20) NOT NULL default '', `address` varchar(255) NOT NULL default '', `province_id` int(10) NOT NULL default '0', `city_id` int(10) NOT NULL default '0', `fwxm` varchar(10) NOT NULL default '', `web` varchar(255) NOT NULL default '', `addtime` varchar(100) NOT NULL default '', `hy` int(11) NOT NULL default '0', `ad_time` int(11) NOT NULL default '0', `publish_time` datetime NOT NULL default '0000-00-00 00:00:00', `ad_money` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM |