AUTO_INCREMENT belongs to a table and produces a value only on insert, so two tables cannot share a numbering space and nothing can reserve a block of ids…
8.0 went GA in April and the correlated subquery can retire. The plans before and after, the recursive CTE that replaces a loop, and the upgrade nobody expects.
The character set named utf8 in MySQL has always been a three-byte subset that cannot store an emoji or several CJK characters, and 8.0 makes the four-byte one…
8.0 defaults to utf8mb4_0900_ai_ci, which sorts and compares differently from the utf8mb4_general_ci a 5.7 database is almost certainly using — and a join between two columns with different…