MySQL · DDL 与数据库对象

浏览 MySQL 迁移中的 DDL 与数据库对象场景；每条详情保留来源状态、正向示例、跨目标结论与验证边界。

122 个场景候选

ALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句alter_algorithm_lock · minor · pending ALTER TABLE 增删主键限制alter_primary_key · critical · pending AUTO_INCREMENT 自增列auto_increment · minor · pending 表/列级 CHARSET 与 COLLATE 子句charset_collation_clause · major · pending MySQL CREATE TABLE ... AS SELECTcreate_table_as_select · major · pending MySQL 降序索引列descending_index · major · pending ENGINE= 存储引擎子句engine_clause · minor · pending MySQL 外键约束foreign_key_constraint · critical · pending 全文索引（FULLTEXT / MATCH AGAINST）fulltext_index · major · pending 生成列（GENERATED ALWAYS AS ... VIRTUAL/STORED）generated_column · major · pending MySQL 多值索引multi_valued_index · critical · pending CREATE TABLE ... LIKE 克隆表结构mysql_create_table_like · major · pending MySQL 索引 USING HASH/BTREE/RTREEmysql_index_type_clause · major · pending MySQL 字符列前缀索引mysql_prefix_index · major · pending MySQL VIEW 定义mysql_view_definition · major · pending MySQL 兼容检查：ALIAS LEN OVERoma.mysql.alias-len-over · major · professional MySQL 兼容检查：AUTOINC INT WIDENoma.mysql.autoinc-int-widen · info · professional MySQL 兼容检查：COL NAME FROM KEYWORDoma.mysql.col-name-from-keyword · critical · professional MySQL 兼容检查：COLUMN COUNT OVERoma.mysql.column-count-over · critical · professional MySQL 兼容检查：COLUMN TOTAL LEN OVERoma.mysql.column-total-len-over · critical · professional MySQL 兼容检查：COLUMNNAME LEN OVERoma.mysql.columnname-len-over · critical · professional MySQL 兼容检查：DB2 COPY OPTIONoma.mysql.db2-copy-option · critical · professional MySQL 兼容检查：DB2 DATA CAPTUREoma.mysql.db2-data-capture · critical · professional MySQL 兼容检查：DB2 INDEX INCLUDEoma.mysql.db2-index-include · critical · professional MySQL 兼容检查：DB2 INDEX OPTIONoma.mysql.db2-index-option · critical · professional MySQL 兼容检查：DB2 INDEX TABLESPACEoma.mysql.db2-index-tablespace · critical · professional MySQL 兼容检查：DB2 LOB OPTIONoma.mysql.db2-lob-option · critical · professional MySQL 兼容检查：DB2 OPTIONS POLICYoma.mysql.db2-options-policy · critical · professional MySQL 兼容检查：DB2 PERIOD TABLEoma.mysql.db2-period-table · critical · professional MySQL 兼容检查：DB2 RETURNS TABLEoma.mysql.db2-returns-table · critical · professional MySQL 兼容检查：DB2 SECURITY POLICYoma.mysql.db2-security-policy · critical · professional MySQL 兼容检查：DB2 SEQ AS TYPEoma.mysql.db2-seq-as-type · critical · professional MySQL 兼容检查：DB2 SEQ OPTIONoma.mysql.db2-seq-option · critical · professional MySQL 兼容检查：DB2 STAGING TABLEoma.mysql.db2-staging-table · critical · professional MySQL 兼容检查：DB2 TABLE OPTIONoma.mysql.db2-table-option · critical · professional MySQL 兼容检查：DB2 VIEW OF TYPEoma.mysql.db2-view-of-type · critical · professional MySQL 兼容检查：DB2 VIEW WITH OPTIONoma.mysql.db2-view-with-option · critical · professional MySQL 兼容检查：DBNAME LEN OVERoma.mysql.dbname-len-over · critical · professional MySQL 兼容检查：DRDS BROADCASToma.mysql.drds-broadcast · critical · professional MySQL 兼容检查：DRDS NON HASH PARTITIONoma.mysql.drds-non-hash-partition · major · professional MySQL 兼容检查：ENCRYPTION OPTIONoma.mysql.encryption-option · critical · professional MySQL 兼容检查：GLOBAL SECONDARY INDEXoma.mysql.global-secondary-index · major · professional MySQL 兼容检查：INDEX COLUMN COUNT OVERoma.mysql.index-column-count-over · critical · professional MySQL 兼容检查：INDEX COUNT OVERoma.mysql.index-count-over · critical · professional MySQL 兼容检查：INDEX LENGTH OVERoma.mysql.index-length-over · critical · professional MySQL 兼容检查：INDEX SINGLE COL LEN OVERoma.mysql.index-single-col-len-over · critical · professional MySQL 兼容检查：INDEXNAME LEN OVERoma.mysql.indexname-len-over · critical · professional MySQL 兼容检查：KEY BLOCK SIZEoma.mysql.key-block-size · major · professional MySQL 兼容检查：PARTITION COUNT OVERoma.mysql.partition-count-over · critical · professional MySQL 兼容检查：PK COLUMN COUNT OVERoma.mysql.pk-column-count-over · critical · professional MySQL 兼容检查：PK LENGTH OVERoma.mysql.pk-length-over · critical · professional MySQL 兼容检查：SEQUENCEoma.mysql.sequence · critical · professional MySQL 兼容检查：STORAGE ENGINEoma.mysql.storage-engine · critical · professional MySQL 兼容检查：TABLENAME LEN OVERoma.mysql.tablename-len-over · critical · professional MySQL 兼容检查：VIEW ALGORITHMoma.mysql.view-algorithm · major · professional MySQL 兼容检查：VIEW DEFINERoma.mysql.view-definer · major · professional MySQL 兼容检查：VIEW SQL SECURITYoma.mysql.view-sql-security · major · professional MySQL 兼容检查：VIEWNAME LEN OVERoma.mysql.viewname-len-over · critical · professional ON UPDATE CURRENT_TIMESTAMP 自动更新时间戳on_update_current_timestamp · major · pending PARTITION BY RANGE 分区表partition_by_range · minor · pending CHECK/ANALYZE PARTITIONpartition_check_analyze · major · pending EXCHANGE PARTITION 分区交换partition_exchange · critical · pending PARTITION BY HASH / KEY / LIST 分区partition_hash_list_key · minor · pending IMPORT/DISCARD PARTITIONpartition_import_discard · critical · pending MySQL 子分区partition_subpartition · critical · pending MySQL SQL 治理检查：COLUMN AUTO INCREMENT INITIAL VALUEperf_static_risk.bb.mysql.column_auto_increment_initial_value · major · professional MySQL SQL 治理检查：COLUMN AUTO INCREMENT MUST INTEGERperf_static_risk.bb.mysql.column_auto_increment_must_integer · major · professional MySQL SQL 治理检查：COLUMN AUTO INCREMENT MUST UNSIGNEDperf_static_risk.bb.mysql.column_auto_increment_must_unsigned · major · professional MySQL SQL 治理检查：COLUMN COMMENTperf_static_risk.bb.mysql.column_comment · major · professional MySQL SQL 治理检查：COLUMN CURRENT TIME COUNT LIMITperf_static_risk.bb.mysql.column_current_time_count_limit · major · professional MySQL SQL 治理检查：COLUMN DISALLOW CHANGEperf_static_risk.bb.mysql.column_disallow_change · major · professional MySQL SQL 治理检查：COLUMN DISALLOW CHANGE TYPEperf_static_risk.bb.mysql.column_disallow_change_type · major · professional MySQL SQL 治理检查：COLUMN DISALLOW CHANGING ORDERperf_static_risk.bb.mysql.column_disallow_changing_order · major · professional MySQL SQL 治理检查：COLUMN DISALLOW DROPperf_static_risk.bb.mysql.column_disallow_drop · major · professional MySQL SQL 治理检查：COLUMN DISALLOW DROP IN INDEXperf_static_risk.bb.mysql.column_disallow_drop_in_index · major · professional MySQL SQL 治理检查：COLUMN DISALLOW SET CHARSETperf_static_risk.bb.mysql.column_disallow_set_charset · major · professional MySQL SQL 治理检查：COLUMN MAXIMUM CHARACTER LENGTHperf_static_risk.bb.mysql.column_maximum_character_length · major · professional MySQL SQL 治理检查：COLUMN MAXIMUM VARCHAR LENGTHperf_static_risk.bb.mysql.column_maximum_varchar_length · major · professional MySQL SQL 治理检查：COLUMN NO NULLperf_static_risk.bb.mysql.column_no_null · major · professional MySQL SQL 治理检查：COLUMN REQUIRE CHARSETperf_static_risk.bb.mysql.column_require_charset · major · professional MySQL SQL 治理检查：COLUMN REQUIRE COLLATIONperf_static_risk.bb.mysql.column_require_collation · major · professional MySQL SQL 治理检查：COLUMN REQUIRE DEFAULTperf_static_risk.bb.mysql.column_require_default · major · professional MySQL SQL 治理检查：COLUMN REQUIREDperf_static_risk.bb.mysql.column_required · major · professional MySQL SQL 治理检查：COLUMN SET DEFAULT FOR NOT NULLperf_static_risk.bb.mysql.column_set_default_for_not_null · major · professional MySQL SQL 治理检查：COLUMN TYPE DISALLOW LISTperf_static_risk.bb.mysql.column_type_disallow_list · major · professional MySQL SQL 治理检查：DATABASE DROP EMPTY DATABASEperf_static_risk.bb.mysql.database_drop_empty_database · major · professional MySQL SQL 治理检查：ENGINE MYSQL USE INNODBperf_static_risk.bb.mysql.engine_mysql_use_innodb · major · professional MySQL SQL 治理检查：INDEX KEY NUMBER LIMITperf_static_risk.bb.mysql.index_key_number_limit · major · professional MySQL SQL 治理检查：INDEX NO DUPLICATE COLUMNperf_static_risk.bb.mysql.index_no_duplicate_column · major · professional MySQL SQL 治理检查：INDEX PK TYPE LIMITperf_static_risk.bb.mysql.index_pk_type_limit · major · professional MySQL SQL 治理检查：INDEX PRIMARY KEY TYPE ALLOWLISTperf_static_risk.bb.mysql.index_primary_key_type_allowlist · major · professional MySQL SQL 治理检查：INDEX TOTAL NUMBER LIMITperf_static_risk.bb.mysql.index_total_number_limit · major · professional MySQL SQL 治理检查：INDEX TYPE ALLOW LISTperf_static_risk.bb.mysql.index_type_allow_list · major · professional MySQL SQL 治理检查：INDEX TYPE NO BLOBperf_static_risk.bb.mysql.index_type_no_blob · major · professional MySQL SQL 治理检查：NAMING COLUMNperf_static_risk.bb.mysql.naming_column · major · professional MySQL SQL 治理检查：NAMING COLUMN AUTO INCREMENTperf_static_risk.bb.mysql.naming_column_auto_increment · major · professional MySQL SQL 治理检查：NAMING IDENTIFIER NO KEYWORDperf_static_risk.bb.mysql.naming_identifier_no_keyword · major · professional MySQL SQL 治理检查：NAMING INDEX FKperf_static_risk.bb.mysql.naming_index_fk · major · professional MySQL SQL 治理检查：NAMING INDEX IDXperf_static_risk.bb.mysql.naming_index_idx · major · professional MySQL SQL 治理检查：NAMING INDEX UKperf_static_risk.bb.mysql.naming_index_uk · major · professional MySQL SQL 治理检查：NAMING TABLEperf_static_risk.bb.mysql.naming_table · major · professional MySQL SQL 治理检查：SCHEMA BACKWARD COMPATIBILITYperf_static_risk.bb.mysql.schema_backward_compatibility · major · professional MySQL SQL 治理检查：SYSTEM EVENT DISALLOW CREATEperf_static_risk.bb.mysql.system_event_disallow_create · major · professional MySQL SQL 治理检查：SYSTEM PROCEDURE DISALLOW CREATEperf_static_risk.bb.mysql.system_procedure_disallow_create · major · professional MySQL SQL 治理检查：SYSTEM VIEW DISALLOW CREATEperf_static_risk.bb.mysql.system_view_disallow_create · major · professional MySQL SQL 治理检查：TABLE COMMENTperf_static_risk.bb.mysql.table_comment · major · professional MySQL SQL 治理检查：TABLE DISALLOW DDLperf_static_risk.bb.mysql.table_disallow_ddl · major · professional MySQL SQL 治理检查：TABLE DISALLOW DMLperf_static_risk.bb.mysql.table_disallow_dml · major · professional MySQL SQL 治理检查：TABLE DISALLOW PARTITIONperf_static_risk.bb.mysql.table_disallow_partition · major · professional MySQL SQL 治理检查：TABLE DISALLOW SET CHARSETperf_static_risk.bb.mysql.table_disallow_set_charset · major · professional MySQL SQL 治理检查：TABLE DISALLOW TRIGGERperf_static_risk.bb.mysql.table_disallow_trigger · major · professional MySQL SQL 治理检查：TABLE DROP NAMING CONVENTIONperf_static_risk.bb.mysql.table_drop_naming_convention · major · professional MySQL SQL 治理检查：TABLE LIMIT SIZEperf_static_risk.bb.mysql.table_limit_size · major · professional MySQL SQL 治理检查：TABLE NO DUPLICATE INDEXperf_static_risk.bb.mysql.table_no_duplicate_index · major · professional MySQL SQL 治理检查：TABLE NO FOREIGN KEYperf_static_risk.bb.mysql.table_no_foreign_key · major · professional MySQL SQL 治理检查：TABLE REQUIRE CHARSETperf_static_risk.bb.mysql.table_require_charset · major · professional MySQL SQL 治理检查：TABLE REQUIRE COLLATIONperf_static_risk.bb.mysql.table_require_collation · major · professional MySQL SQL 治理检查：TABLE REQUIRE PKperf_static_risk.bb.mysql.table_require_pk · major · professional MySQL SQL 治理检查：TABLE TEXT FIELDS TOTAL LENGTHperf_static_risk.bb.mysql.table_text_fields_total_length · major · professional performance_schema 系统库访问performance_schema_access · major · pending 空间类型与空间索引（GEOMETRY / SPATIAL INDEX）spatial_types · major · pending MySQL TABLESPACE DDLtablespace_ddl · major · pending