建表报错：Please consider using UTF8MB4 in order to be unambiguous

最新推荐文章于 2024-09-27 09:21:07 发布
最新推荐文章于 2024-09-27 09:21:07 发布
阅读量1.2k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44976611/article/details/112567575
版权

14:20:34 create table login_record ( userid int not null, time date default null )engine=innodb default charset=utf8 0 row(s) affected, 1 warning(s): 3719 ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 0.109 sec

参考链接

MySQL数据库常用报错解决方法
QA的自我修养
08-28 1033
MySQL报错解决方法1）Warning: (3719, u"'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")2）pymysql.err.InternalError: (1130, u"Host '10.0.0.5
【mysql】utf8和utf8mb4关联字符集转化问题
践行见远
11-10 285
环境介绍： ---DB version: percona server5.7.27-30-log ---utf8 CREATETABLE`emp` ( `id`bigint(20) unsignedNOTNULLAUTO_INCREMENT, `empno` mediumint(8) unsignedNOTNULLDEFAULT'0', `ename`varchar(20)NOTNULLDEF...
mysql使用utf8mb4经验总结
zoupanpan1的博客
11-11 505
mysql使用utf8mb4经验吐血总结 utf8 与 utf8mb4 异同 The character set named utf8 uses a maximum of three bytes per character and contains only BMP characters. The utf8mb4 character set uses a maximum of four bytes per character supports supplementary characters: - F
UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI
最新发布
Debug yourself!
09-27 543
这个警告是因为pandas的read_sql函数需要SQLAlchemy连接对象、数据库字符串 URI 或sqlite3的 DBAPI2 连接，而其他 DBAPI2 对象未经过测试。为了避免此警告，并确保代码的稳定性，建议使用SQLAlchemy来管理数据库连接。
mysql使用utf8mb4经验吐血总结
weixin_30677475的博客
12-22 369
ACMUG征集原创技术文章。详情请添加 A_CMUG或者扫描文末二维码关注我们的微信公众号。有奖征稿，请发送稿件至：acmug@acmug.com。3306现金有奖征稿说明：知识无价，劳动有偿，ACMUG特约撰稿人有奖回报计划（修订版） 作者简介：周晓 网络常用id seanlook 。以前在TP-LINK做了2年Oracle DBA，后来专职做MySQL了。平时在工作中遇到的些问...
mysql set语句_第07期：有关 MySQL 字符集的 SQL 语句
weixin_39919089的博客
11-28 158
本篇为理清字符集的续篇(上一篇：第06期：梳理 MySQL 字符集的相关概念)，重点讲述字符集涉及到的 sql 语句用法。一、character introducer翻译过来就是字符引导。也就是针对字符串，显式的给定一个字符编码和排序规则，不受系统参数的影响。语法很简单：[_charset_name] 'string' [COLLATE collation_name]示例：字符串"北京加油❤!"-...
MySQL字符集utf8、utf8mb4、utf8mb4_general_ci、utf8mb4_unicode_ci的区别
识途老码
06-01 7883
数据库day0601 性能测试里的并发,测试百万级数据. 一.为什么要学习数据库 1. 为了方便查询数据 2. 为了持久保存数据 二.数据库的相关概念 DBMS ,DB ,SQL 答: ​ DB 数据库,保存数据的容器 ​ DBMS 数据管理系统. 银行业一般使用Oracle和DB2. DB2 是IBM的数据库产品. ​ SQL : 结构化查询语句. 测试的角度是站在用户角度的,测试过程中尽量不使用数据库进行数据操作. 三.数据库存储数据的特点 表是放在数据库里面的; 数据是存放在表
2023-06-05T11:35:59.033048Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2023-06-05T11:35:59.033071Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2023-06-05T11:35:59.297121Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-06-05T11:36:01.786213Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-06-05T11:36:06.009613Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
06-06
其中最值得注意的是关于字符集和校对规则的警告，MySQL 建议在未来的版本中使用 UTF8MB4 作为字符集，以避免歧义。此外，该日志还显示了 InnoDB 存储引擎的初始化过程，以及一个关于 CA 证书是自签名的警告。如果你...
Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias
漫步量化
04-11 1848
问题描述 在Python使用pymysql出现如题错误： /home/data/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alia...
2023-05-28T07:02:28.900903Z 0 [System] [MY-013169] [Server] D:\DB\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 19088 2023-05-28T07:02:28.902649Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2023-05-28T07:02:28.905039Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2023-05-28T07:02:28.905050Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\DB\mysql-8.0.17-winx64\data\ is unusable. You can remove all files that the server added to it. 2023-05-28T07:02:28.906164Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-05-28T07:02:28.906279Z 0 [System] [MY-010910] [Server] D:\DB\mysql-8.0.17-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
05-29
这段信息看起来是MySQL数据库服务器启动过程中的一些报错信息。最后一行显示MySQL服务器启动失败。报错信息中提到指定的数据目录中已经存在文件，这可能是导致启动失败的原因之一。建议您检查一下数据目录中是否存在...
2023-05-28T06:56:35.232970Z 0 [System] [MY-013169] [Server] D:\DB\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 10068 2023-05-28T06:56:35.235056Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2023-05-28T06:56:35.237564Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2023-05-28T06:56:35.237582Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\DB\mysql-8.0.17-winx64\data\ is unusable. You can remove all files that the server added to it. 2023-05-28T06:56:35.241999Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-05-28T06:56:35.242236Z 0 [System] [MY-010910] [Server] D:\DB\mysql-8.0.17-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
05-29
[MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. [MY-013236] [Server] The designated data directory D:\DB\mysql-8.0.17-winx64\data\ is unusable. You can ...
Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias fo
cuicui_ruirui的博客
05-02 1万+
pymysql执行写入mysql的操作时报错： Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be...
python用mysql建表的UTF8MB3、UTF8MB4警告
0->1的博客
11-18 7894
今天想练习下myslq的数据库索引，看的教程是https://www.cnblogs.com/chenshishuo/p/5030029.html，结果在创建数据库表的时候就遇到了一个警告。 这是我的python.py # !/usr/bin/env python # -*- coding: utf-8 -*- """ @Author: P♂boy @License: (C) Copyright ...
完美解决数据库设置字符集报错| Warning | 3719 | ‘utf8‘ is currently an alias for the character set UTF8MB3, but ...
Mortalz7
11-07 3414
| Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. | | Warning | 3778 | 'utf8mb3_bin' is a collation of the deprecat
【MYSQL】MYSQL报错解决方法： Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but...
dengbeng4485的博客
12-12 2448
　　 　　用python3.6.5创建mysql库时出现如下报错，虽然报错，但是数据库可以插入成功。 D:\python3\lib\site-packages\pymysql\cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will ...
mysql 8中utf8和utf8mb4运行时的编码告警提醒
fuck487的博客
02-13 6554
2020-01-14T21:14:26.516484Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future releas...
MySQL8.0.13安装
热门推荐
daocaoren92wq的博客
10-24 2万+
下载 官方：https://dev.mysql.com/downloads/mysql/ 再贴一个安装文件下载网址：https://dev.mysql.com/downloads/mirrors/ 解压 解压之后没有my.ini文件（我的端口设置的3308），截图中是我增加的 [client] port = 3308 default-character-set = utf...
用mysqld --initialize 进行初始化mysql，等待初始化完成会生成一个后缀名为.err的文件，文件中未找到找root账户和root密码，.err文件显示： 2023-07-14T06:06:30.712533Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2023-07-14T06:06:30.713009Z 0 [System] [MY-013169] [Server] D:\mysql\mysql-8.0.33- winx64\bin\mysqld.exe (mysqld 8.0.33) initializing of server in progress as process 10552 2023-07-14T06:06:30.715582Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2023-07-14T06:06:30.740834Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-07-14T06:06:30.940382Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-07-14T06:06:31.904232Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: SPp;j#LD7lXu
07-20
在初始化 MySQL 的过程中，如果没有在错误文件中找到 root 账户和密码，那么...j#LD7lXu。... 要登录 MySQL，你可以使用以下命令： ``` mysql -u root -p ...ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';...
记录python连接MySQL时的一个问题
zhidong_lv的博客
06-06 6397
代码：#! user/bin/env python3 # -*- coding: utf-8 -*- from sqlalchemy import Column, String, create_engine from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值