修改Mysql表名

Written by 正冰 on 2019, September 8, 7:05 AM. 技术归总

假定数据库名为is36，其中有个一个user表，要将其变为users，则：

先进入该数据库

use is36;

再执行修改

ALTER TABLE `user` RENAME `users`;

上一篇: 下载最新微软官方Microsoft Remote Desktop for Mac
下一篇: 解决MOTOCMS系统更换主机后无法访问的问题（空白页或500 error）

发表评论


数据库出错:

MySQL Query Error
Mysql error description: Duplicate entry '0' for key 'uid'
Mysql error number: 1062
Date: 2024-06-04 @ 06:00
Script: http://blog.is36.com/index.php/module/action/param1/tagslist/page/3/user/%E6%AD%A3%E5%86%B0/wap/comments/archives/484/category/technology_all/links/date/202207/archives/487/archives/489/links/archives/436/links/https:/blog.is36.com/index.php/module/action/param1/tagslist/page/3/user/%E6%AD%A3%E5%86%B0/wap/comments/archives/484/category/technology_all/links/date/202207/archives/487/archives/489/links/archives/436/links/page/7/?action=show&id=466