MYSQL 迁移国产数据库兼容性改造总览

GET_LOCK / RELEASE_LOCK 咨询锁函数undeclared · major · my.func.advisory_locks ALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句undeclared · minor · my.ddl.alter_algorithm ALTER TABLE 增删主键限制undeclared · critical · my.ddl.alter_primary_key AUTO_INCREMENT 自增列undeclared · minor · my.ddl.auto_increment 反引号标识符undeclared · minor · my.syntax.backtick MySQL BINARY/VARBINARY 类型undeclared · major · my.type.binary_varbinary MySQL BIT 类型undeclared · major · my.type.bit 表/列级 CHARSET 与 COLLATE 子句undeclared · major · my.ddl.charset_collation CHECK 约束执行与静默忽略差异undeclared · critical · my.ddl.check_constraint CHECK TABLE 管理语句undeclared · major · my.admin.check_table CHECKSUM TABLE 校验语句undeclared · major · my.admin.checksum_table 列 DEFAULT 表达式兼容差异undeclared · critical · my.ddl.default_expression DECLARE ... HANDLER 条件处理器undeclared · major · my.proc.handler CONVERT(expr USING charset) 字符集转换undeclared · minor · my.func.convert_using MySQL CREATE TABLE ... AS SELECTundeclared · major · my.ddl.create_table_as_select DATE_ADD / DATE_SUB / ADDDATE / SUBDATE 日期运算函数undeclared · minor · my.func.date_add_interval DATE_FORMAT 函数（% 格式符体系）undeclared · minor · my.func.date_format MySQL DATETIME/TIMESTAMP 类型语义undeclared · critical · my.type.datetime_timestamp DEFINER 定义者权限子句undeclared · minor · my.proc.definer MySQL 降序索引列undeclared · major · my.index.descending ENGINE= 存储引擎子句undeclared · minor · my.ddl.engine_clause ENUM 枚举类型undeclared · major · my.type.enum 事件调度器（CREATE EVENT / ON SCHEDULE）undeclared · major · my.proc.event MySQL ExtractValue XML 函数undeclared · major · my.func.extractvalue MySQL 外键约束undeclared · critical · my.ddl.foreign_key 全文索引（FULLTEXT / MATCH AGAINST）undeclared · major · my.ddl.fulltext 生成列（GENERATED ALWAYS AS ... VIRTUAL/STORED）undeclared · major · my.ddl.generated_column GROUP_CONCAT 聚合函数undeclared · minor · my.func.group_concat MySQL HANDLER 低层表访问语句undeclared · critical · my.syntax.handler IF(expr, v1, v2) 流程控制函数undeclared · minor · my.func.if IFNULL 函数undeclared · minor · my.func.ifnull USE / FORCE / IGNORE INDEX 索引提示undeclared · minor · my.syntax.index_hints INSERT IGNORE 容错插入undeclared · major · my.syntax.insert_ignore 整数显示宽度 INT(n)undeclared · minor · my.type.int_display_width JSON 列 -> 取 JSON 操作符undeclared · minor · my.syntax.json_arrow JSON 列 ->> 取文本操作符undeclared · minor · my.syntax.json_arrow_text JSON_* 函数族undeclared · major · my.func.json_family LAST_INSERT_ID 函数undeclared · major · my.func.last_insert_id MySQL LATERAL 派生表undeclared · critical · my.syntax.lateral_derived LIMIT offset, count 逗号写法undeclared · minor · my.syntax.limit_comma LOAD DATA [LOCAL] INFILE 批量装载undeclared · major · my.syntax.load_data MySQL LOAD_FILE 函数undeclared · critical · my.func.load_file LOCK TABLES / UNLOCK TABLESundeclared · major · my.syntax.lock_tables MySQL MASTER_POS_WAIT 复制等待undeclared · blocker · my.func.master_pos_wait MySQL MEDIUMINT 类型undeclared · major · my.type.mediumint MySQL 多值索引undeclared · critical · my.index.multi_valued AES_ENCRYPT/AES_DECRYPT 密文兼容undeclared · blocker · my.func.aes_crypto MySQL Enterprise 非对称加密函数族undeclared · blocker · my.func.asymmetric_crypto FROM_BASE64/TO_BASE64 编码细节undeclared · major · my.func.base64 BIN/BIT_COUNT 位字符串辅助函数undeclared · major · my.func.bit_helpers MySQL 位异或 ^undeclared · major · my.op.bitwise_xor MySQL BLOB 基础类型undeclared · major · my.type.blob_base MySQL BOOLEAN/BOOL 类型undeclared · minor · my.type.boolean MySQL 逻辑 XORundeclared · major · my.op.boolean_xor DAY/DAYOFWEEK/DAYOFYEAR 日序函数族undeclared · critical · my.func.calendar_day LCASE/UCASE 大小写别名undeclared · major · my.func.case_alias CHAR 数值序列转字符undeclared · critical · my.func.char_code MySQL CHAR/VARCHAR 类型undeclared · minor · my.type.character_base COMPRESS/UNCOMPRESS 二进制格式undeclared · critical · my.func.compression MySQL CONCAT 函数undeclared · major · my.func.concat CONCAT_WS 分隔拼接的 NULL 语义undeclared · major · my.func.concat_ws CONNECTION_ID/USER/SYSTEM_USER 会话身份undeclared · critical · my.func.connection_identity MySQL CONVERT_TZ 时区转换undeclared · critical · my.func.convert_tz CREATE TABLE ... LIKE 克隆表结构undeclared · major · my.ddl.create_table_like MySQL CURDATE 函数undeclared · major · my.func.curdate MySQL DATABASE/SCHEMA 当前库函数undeclared · major · my.func.current_database CURTIME/SYSDATE 当前时间语义undeclared · critical · my.func.current_time DAYNAME/MONTHNAME 本地化名称undeclared · major · my.func.date_name MySQL DATE 类型undeclared · minor · my.type.date_base DATEDIFF 整日边界差undeclared · critical · my.func.datediff DELETE IGNORE 错误降级undeclared · critical · my.dml.delete_ignore DELETE ORDER BY / LIMITundeclared · major · my.dml.delete_order_limit MySQL 除法零除语义undeclared · critical · my.op.division_zero_semantics MySQL bare DOUBLE 类型别名undeclared · major · my.type.double_alias FIELD/ELT 位置与取值函数undeclared · major · my.func.field_elt FIND_IN_SET 逗号集合查找undeclared · critical · my.func.find_in_set MySQL FIXED 定点数别名undeclared · minor · my.type.fixed_alias GROUP BY 后缀式 WITH ROLLUPundeclared · major · my.syntax.group_by_with_rollup HEX/UNHEX 二进制与文本转换undeclared · critical · my.func.hex_helpers MySQL 索引 USING HASH/BTREE/RTREEundeclared · major · my.index.type_clause