mysql修改存储引擎，mysql修改表字符集，mysql修改列字符集，mysql修改排序规则，mysql修改行格式

目录

• 【1】修改存储引
• 【2】修改字符集与排序规则
• 【3】修改行格式

 

---

回到顶部

【1】修改存储引

ALTER TABLE `qipa250_articles` ENGINE=INNODB;
ALTER TABLE `qipa250_articles_text` ENGINE=INNODB;
ALTER TABLE `qipa250_authors` ENGINE=INNODB;
ALTER TABLE `qipa250_comments` ENGINE=INNODB;
ALTER TABLE `qipa250_comments_description` ENGINE=INNODB;
ALTER TABLE `popular_searches` ENGINE=INNODB;
ALTER TABLE `un_products_to_wishlists` ENGINE=INNODB;
ALTER TABLE `un_wishlists` ENGINE=INNODB;

回到顶部

【2】修改字符集与排序规则

-- 修改数据库默认字符集与排序规则
ALTER DATABASE `zcqipa250` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

-- 修改表字符集与排序规则
-- 有数据的情况下 

ALTER TABLE `qipa250_articles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `qipa250_articles_text` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `qipa250_authors` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `qipa250_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `qipa250_comments_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `popular_searches` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `un_products_to_wishlists` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `un_wishlists` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

-- 修改字段的
alter table `t_settle_apply ` modify column nike_name varchar(500) character set utf8 collate utf8_general_ci comment '昵称';

回到顶部

【3】修改行格式

ALTER TABLE 表名 ROW_FORMAT=行格式名称