You are here
CREATE TABLE `phpcms_admin` ( `userid` mediumint(8) unsigned NOT NULL, `username` char(20) NOT NULL, `allowmultilogin` tinyint(1) unsigned NOT NULL default '0', `alloweditpassword` tinyint(1) unsigned NOT NULL default '0', `editpasswordnextlogin` tinyint
星期二, 2017-06-13 10:35 — adminshiping1
10
MySQL Query : CREATE TABLE `phpcms_admin` ( `userid` mediumint(8) unsigned NOT NULL, `username` char(20) NOT NULL, `allowmultilogin` tinyint(1) unsigned NOT NULL default '0', `alloweditpassword` tinyint(1) unsigned NOT NULL default '0', `editpasswordnextlogin` tinyint(1) unsigned NOT NULL default '0', `disabled` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`userid`)) TYPE=MyISAM DEFAULT CHARSET=utf8 MySQL 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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 1 MySQL Errno : 1064 Message : MySQL Query Error
收起
收起
推荐于2016-01-12 22:45:27 最佳答案
你的建表语句有语法错误，可能和具体的mysql版本有关系，建议这样改：
1 2 3 4 5 6 7 8 9 | CREATE TABLE `phpcms_admin` ( `userid` mediumint(8) unsigned NOT <a href="https://www.baidu.com/s?wd=NULL&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBmyn4PWRLuj-brHc3PvDd0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPHR3PjDvPjDk"target="_blank" class="baidu-highlight">NULL</a>,`username` char(20) NOT <a href="https://www.baidu.com/s?wd=NULL&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBmyn4PWRLuj-brHc3PvDd0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPHR3PjDvPjDk" target="_blank" class="baidu-highlight">NULL</a>,`allowmultilogin` tinyint(1) unsigned NOT <a href="https://www.baidu.com/s?wd=NULL&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBmyn4PWRLuj-brHc3PvDd0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPHR3PjDvPjDk"target="_blank" class="baidu-highlight">NULL</a> default '0',`alloweditpassword` tinyint(1) unsigned NOT NULL default '0',`editpasswordnextlogin` tinyint(1) unsigned NOT NULL default '0',`disabled` tinyint(1) unsigned NOT NULL default '0',PRIMARY KEY (`userid`)) <a href="https://www.baidu.com/s?wd=ENGINE&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBmyn4PWRLuj-brHc3PvDd0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPHR3PjDvPjDk" target="_blank" class="baidu-highlight">ENGINE</a>=MyISAM DEFAULT <a href="https://www.baidu.com/s?wd=CHARSET&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBmyn4PWRLuj-brHc3PvDd0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPHR3PjDvPjDk" target="_blank" class="baidu-highlight">CHARSET</a>=utf8 |
其实只是将TYPE=MyISAM改成ENGINE=MyISAM。
来自 https://zhidao.baidu.com/question/558416411.html
普通分类: