Warning: (3719, “‘utf8’ is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.”)
set for to in The is by be
2023-09-14 09:12:19 时间
【1】本地版本 Mysql 8.0.12
创建表SQL:
DROP TABLE IF EXISTS students; CREATE TABLE `students` ( `sId` INT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sName` VARCHAR(100) NOT NULL, `sAge` INT(10) NOT NULL, `sAddr` VARCHAR(200) DEFAULT NULL, `sGrade` INT(10) DEFAULT NULL, `sStuId` VARCHAR(20) DEFAULT NULL, `sSex` INT(10) UNSIGNED DEFAULT NULL, PRIMARY KEY (`sId`), INDEX `idx_name` (`sName`) ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
执行提示警告3719 内容:
Warning: (3719, “‘utf8’ is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.”)
翻译:
警告:(3719),“UTF 8”目前是字符集UTF8MB3的别名,在将来的版本中将被UTF8MB4替换。请考虑使用UTF8MB4,以便明确无误。“)
【2】解决方案
(1)修改my.ini
[client]
port=3306
default-character-set=utf8mb4
[mysqld]
port=3306
character_set_server=utf8mb4
#解压目录
basedir=D:\MySql\mysql-8.0.12-winx64\bin
#解压目录下data目录
datadir=D:\MySql\mysql-8.0.12-winx64\data
federated
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
(2)修改创建表语句
DROP TABLE IF EXISTS students; CREATE TABLE `students` ( `sId` INT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sName` VARCHAR(100) NOT NULL, `sAge` INT(10) NOT NULL, `sAddr` VARCHAR(200) DEFAULT NULL, `sGrade` INT(10) DEFAULT NULL, `sStuId` VARCHAR(20) DEFAULT NULL, `sSex` INT(10) UNSIGNED DEFAULT NULL, PRIMARY KEY (`sId`), INDEX `idx_name` (`sName`) ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4
修改默认字符集 :DEFAULT CHARSET=utf8mb4
不再提示此警告内容。
Good Good Study, Day Day Up.
顺序 选择 循环 总结
相关文章
- c++ set集合的使用方法详解
- Set A Light 3D Studio for Mac(3D摄影棚布光软件) v2.00.15汉化版
- ORA-24336: invalid result set descriptor ORACLE 报错 故障修复 远程处理
- ORA-27076: unable to set limit for open files ORACLE 报错 故障修复 远程处理
- ORA-27354: attribute string cannot be set for lightweight jobs ORACLE 报错 故障修复 远程处理
- ORA-31469: cannot enable Change Data Capture for change set string ORACLE 报错 故障修复 远程处理
- ORA-38443: An attribute set should be assigned to the expression set for statistics collection. ORACLE 报错 故障修复 远程处理
- ORA-38444: statistics do not exist for the expression set ORACLE 报错 故障修复 远程处理
- ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET ORACLE 报错 故障修复 远程处理
- ORA-02069: global_names parameter must be set to TRUE for this operation ORACLE 报错 故障修复 远程处理
- MySQL Error number: MY-010919; Symbol: ER_TRG_CREATION_CTX_NOT_SET; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011678; Symbol: ER_GRP_RPL_INVALID_TRANS_WRITE_SET_EXTRACTION_VALUE; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-15703: invalid version number “number” for SQL tuning set staging table ORACLE 报错 故障修复 远程处理
- mysql用find_in_set代替like搜索提高性能详解数据库
- 功能熟悉Oracle的SET功能,提高工作效率(oracle的set)
- 的应用使用For语句提高Linux效率(linux中for语句)
- MySQL存储过程中使用FOR循环的实现(mysql存储过程for循环)
- Oracle:学习如何使用For遍历(oracle for遍历)
- 深入了解MySQL中的SET集合使用方法(mysql中set集合)
- MySQL中SET用法详解(mysql中set 用法)
- 深入浅出Redis集群Set的简单操作(redis集群set过程)
- Oracle SET日期 驾驭时间,管理数据(oracle set日期)
- 学习Oracle中的For语句搭建数据库应用的基础(oracle for语法)
- Redis获取Set中元素数量的方法(redis获取set个数)