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

GET_LOCK / RELEASE_LOCK 咨询锁函数undeclared · major · my.func.advisory_locks ALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句undeclared · minor · my.ddl.alter_algorithm AUTO_INCREMENT 自增列undeclared · minor · my.ddl.auto_increment 反引号标识符undeclared · minor · my.syntax.backtick 表/列级 CHARSET 与 COLLATE 子句undeclared · major · my.ddl.charset_collation DECLARE ... HANDLER 条件处理器undeclared · major · my.proc.handler CONVERT(expr USING charset) 字符集转换undeclared · minor · my.func.convert_using DATE_ADD / DATE_SUB / ADDDATE / SUBDATE 日期运算函数undeclared · minor · my.func.date_add_interval DATE_FORMAT 函数（% 格式符体系）undeclared · minor · my.func.date_format DEFINER 定义者权限子句undeclared · minor · my.proc.definer ENGINE= 存储引擎子句undeclared · minor · my.ddl.engine_clause ENUM 枚举类型undeclared · major · my.type.enum 事件调度器（CREATE EVENT / ON SCHEDULE）undeclared · major · my.proc.event 全文索引（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 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 列 -> / ->> 操作符undeclared · minor · my.syntax.json_arrow JSON_* 函数族undeclared · major · my.func.json_family LAST_INSERT_ID 函数undeclared · major · my.func.last_insert_id LIMIT offset, count 逗号写法undeclared · minor · my.syntax.limit_comma LOAD DATA [LOCAL] INFILE 批量装载undeclared · major · my.syntax.load_data LOCK TABLES / UNLOCK TABLESundeclared · major · my.syntax.lock_tables /*+ ... */ 优化器提示（MySQL 8.0 风格）undeclared · minor · my.syntax.optimizer_hint INSERT ... ON DUPLICATE KEY UPDATEundeclared · major · my.syntax.on_duplicate_key ON UPDATE CURRENT_TIMESTAMP 自动更新时间戳undeclared · major · my.ddl.on_update_timestamp PARTITION BY RANGE 分区表undeclared · minor · my.ddl.partition_by_range PARTITION BY HASH / KEY / LIST 分区undeclared · minor · my.ddl.partition_hash_list_key 显式分区选择（FROM t PARTITION (p)）undeclared · minor · my.syntax.partition_selection REPLACE INTO 语句undeclared · major · my.syntax.replace_into SELECT ... INTO OUTFILE / DUMPFILEundeclared · major · my.syntax.into_outfile SET GLOBAL/SESSION 变量与 sql_modeundeclared · major · my.syntax.set_variables SET 集合类型undeclared · major · my.type.set SHOW 元数据语句undeclared · minor · my.syntax.show_statements SIGNAL / RESIGNAL 抛出条件undeclared · major · my.proc.signal 空间类型与空间索引（GEOMETRY / SPATIAL INDEX）undeclared · major · my.ddl.spatial SQL_CALC_FOUND_ROWS / FOUND_ROWS 分页计数undeclared · major · my.func.found_rows 存储函数（CREATE FUNCTION）undeclared · major · my.proc.stored_function 存储过程（CREATE PROCEDURE）undeclared · major · my.proc.stored_procedure STR_TO_DATE 函数undeclared · minor · my.func.str_to_date STRAIGHT_JOIN 连接顺序固定undeclared · minor · my.syntax.straight_join SUBSTRING_INDEX 函数undeclared · minor · my.func.substring_index 系统变量 @@var 读取undeclared · minor · my.syntax.system_variables TINYTEXT/MEDIUMTEXT/LONGTEXT 与 BLOB 族undeclared · minor · my.type.text_blob_variants TINYINT(1) 布尔惯用法undeclared · minor · my.type.tinyint1 触发器（CREATE TRIGGER）undeclared · major · my.proc.trigger UNIX_TIMESTAMP / FROM_UNIXTIME 函数undeclared · minor · my.func.unix_timestamp UNSIGNED 无符号整数属性undeclared · major · my.type.unsigned 用户变量 @varundeclared · major · my.syntax.user_variables ZEROFILL 补零显示属性undeclared · minor · my.type.zerofill GET_LOCK / RELEASE_LOCK 咨询锁函数undeclared · major · my.func.advisory_locks ALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句undeclared · minor · my.ddl.alter_algorithm AUTO_INCREMENT 自增列undeclared · minor · my.ddl.auto_increment 反引号标识符undeclared · minor · my.syntax.backtick 表/列级 CHARSET 与 COLLATE 子句undeclared · major · my.ddl.charset_collation DECLARE ... HANDLER 条件处理器undeclared · major · my.proc.handler CONVERT(expr USING charset) 字符集转换undeclared · minor · my.func.convert_using DATE_ADD / DATE_SUB / ADDDATE / SUBDATE 日期运算函数undeclared · minor · my.func.date_add_interval DATE_FORMAT 函数（% 格式符体系）undeclared · minor · my.func.date_format DEFINER 定义者权限子句undeclared · minor · my.proc.definer ENGINE= 存储引擎子句undeclared · minor · my.ddl.engine_clause ENUM 枚举类型undeclared · major · my.type.enum 事件调度器（CREATE EVENT / ON SCHEDULE）undeclared · major · my.proc.event 全文索引（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 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 列 -> / ->> 操作符undeclared · minor · my.syntax.json_arrow JSON_* 函数族undeclared · major · my.func.json_family LAST_INSERT_ID 函数undeclared · major · my.func.last_insert_id LIMIT offset, count 逗号写法undeclared · minor · my.syntax.limit_comma LOAD DATA [LOCAL] INFILE 批量装载undeclared · major · my.syntax.load_data