欢迎各位兄弟 发布技术文章
这里的技术是共享的
你的建表语句有语法错误,可能和具体的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