Mysql:Changes in MySQL 8.0.13 (2018-10-22, General Availability):utf8mb3 ->utf8mb4
Changes in MySQL 8.0.13 (2018-10-22, General Availability)
-
...
-
InnoDB: Support for
TABLESPACE = innodb_file_per_table
andTABLESPACE = innodb_temporary
clauses withCREATE TEMPORARY TABLE
is deprecated and will be removed in a future MySQL version. -
The
utf8mb3
character set is deprecated and will be removed in a future MySQL version. Please useutf8mb4
instead.
-
Incompatible Change: The deprecated
ASC
orDESC
qualifiers forGROUP BY
clauses have been removed. Queries that previously relied onGROUP BY
sorting may produce results that differ from previous MySQL versions. To produce a given sort order, provide anORDER BY
clause.Queries and stored program definitions from MySQL 8.0.12 or lower that use
ASC
orDESC
qualifiers forGROUP BY
clauses should be amended. Otherwise, upgrading to MySQL 8.0.13 or higher may fail, as may replicating to MySQL 8.0.13 or higher slave servers.
-
Important Change: Setting user variables in statements other than
SET
is now deprecated due to issues that included those listed here:-
The order of evaluation for expressions involving user variables was undefined.
-
The default result type of a variable is based on its type at the beginning of the statement, which could have unintended effects when a variable holding a value of one type at the beginning of a statement was assigned a new value of a different type in the same statement.
-
HAVING
,GROUP BY
, andORDER BY
clauses, when referring to a variable that was assigned a value in the select expression list, did not work as expected because the expression was evaluated on the client and so it was possible for stale column values from a previous row to be used.
Syntax such as
SELECT @var, @var:=@var+1
is still accepted in MySQL 8.0 for backward compatibility, but is subject to removal in a future MySQL version. -
相关文章
- 史上最简单的 MySQL 教程(二十六)「数据备份与还原」
- mysql select in 怎么优化
- 关于mysql数据库在输入password后,滴的一声直接退出界面的解决的方法(具体办法)
- MySQL in Windows安装以及异名恢复的简单过程
- MySQL:模糊查询LIKE、REGEXP、IN
- Mysql:Changes in MySQL 8.0.19 (2020-01-13, General Availability):(!)可以在windows下正常工作了!
- Mysql:8.0.19:Upgrading Mysql:升级
- Mysql批量更新的三种方式
- The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead [duplicate]
- MySQL 存储过程传参之in, out, inout 参数用法
- MySQLdb in Python: “Can't connect to MySQL server on 'localhost'”
- 2022-09-02 mysql/stonedb-IN句子使用HASH优化后-查询多个字符串结果不符合预期记录
- mysql 5.7 新特性之 json 类型 创建索引
- Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
- Home / Python MySQL Tutorial / Calling MySQL Stored Procedures in Python Calling MySQL Stored Procedures in Python
- How do I set the default schema for a user in MySQL
- mysql数据文件迁移到新的硬盘分区的方法
- Mysql中使用存储过程返回查询多个表的数据信息
- MYSQL因IN的范围太大导致索引失效问题
- 地理空间数据Geometry在MySQL中使用
- 记录阿里云服务器mysql被黑