##设置utf8
ALTER TABLE user_pdf CHANGE title title VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',ALGORITHM=inplace,LOCK=NONE;
##设置utf8mb4
ALTER TABLE user_pdf CHANGE title title VARCHAR (255) CHARACTER
SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',ALGORITHM=inplace,LOCK=NONE;
设置字符集编码
1 创建表的时候写注释 2 修改表的注释 alter table test1 comment ‘修改后的表的注释’...
1：删除列 ALTER TABLE 【表名字】 DROP 【列名称】 2：增加列 ALTER TABLE 【表名字...
USE mysql;ALTER USER 'root'@'%' IDENTIFIED WITH mysql_nat...
MySql中ALTER的用法 1.案例 增加mysql表一个字段ALTER TABLE 表名 ADD...
USE mysql; ALTER USER 'root'@'localhost' IDENTIFIED WITH ...
MySQL5.7 ALTER information_schema 参考 MySQL官网ALT...
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_nativ...
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_nativ...
alter user 'root'@'%' identified with mysql_native_passwo...
本文标题：mysql alter小结
本文链接：https://www.haomeiwen.com/subject/lactprtx.html
网友评论