继续按专业类别进入
369 个场景候选
GET_LOCK / RELEASE_LOCK 咨询锁函数advisory_lock_funcs · major · pendingALTER TABLE ALGORITHM= / LOCK= 在线 DDL 子句alter_algorithm_lock · minor · pendingALTER TABLE 增删主键限制alter_primary_key · critical · pendingAUTO_INCREMENT 自增列auto_increment · minor · pending反引号标识符backtick_quoting · minor · pendingMySQL BINARY/VARBINARY 类型binary_varbinary_type · major · pendingMySQL BIT 类型bit_type · major · pending表/列级 CHARSET 与 COLLATE 子句charset_collation_clause · major · pendingCHECK 约束执行与静默忽略差异check_constraint · critical · pendingCHECK TABLE 管理语句check_table · major · pendingCHECKSUM TABLE 校验语句checksum_table · major · pending列 DEFAULT 表达式兼容差异column_default_expression · critical · pendingDECLARE ... HANDLER 条件处理器condition_handler · major · pendingCONVERT(expr USING charset) 字符集转换convert_using_charset · minor · documentedMySQL CREATE TABLE ... AS SELECTcreate_table_as_select · major · pendingDATE_ADD / DATE_SUB / ADDDATE / SUBDATE 日期运算函数date_add_interval · minor · documentedDATE_FORMAT 函数(% 格式符体系)date_format_func · minor · professionalMySQL DATETIME/TIMESTAMP 类型语义datetime_timestamp_type · critical · pendingDEFINER 定义者权限子句definer_clause · minor · pendingMySQL 降序索引列descending_index · major · pendingENGINE= 存储引擎子句engine_clause · minor · pendingENUM 枚举类型enum_type · major · pending事件调度器(CREATE EVENT / ON SCHEDULE)event_scheduler · major · pendingMySQL ExtractValue XML 函数extractvalue_func · major · professionalMySQL 外键约束foreign_key_constraint · critical · pending全文索引(FULLTEXT / MATCH AGAINST)fulltext_index · major · pending生成列(GENERATED ALWAYS AS ... VIRTUAL/STORED)generated_column · major · pendingGROUP_CONCAT 聚合函数group_concat · minor · professionalMySQL HANDLER 低层表访问语句handler_statement · critical · pendingIF(expr, v1, v2) 流程控制函数if_func · minor · documentedIFNULL 函数ifnull_func · minor · documentedUSE / FORCE / IGNORE INDEX 索引提示index_hints · minor · pendingINSERT IGNORE 容错插入insert_ignore · major · pending整数显示宽度 INT(n)int_display_width · minor · pendingJOIN ON 中的相关子查询join_on_correlated_subquery · critical · pendingJSON 列 -> 取 JSON 操作符json_arrow_operator.json_value · minor · documentedJSON 列 ->> 取文本操作符json_arrow_operator.text_value · minor · professionalJSON_* 函数族json_functions · major · professionalLAST_INSERT_ID 函数last_insert_id · major · pendingMySQL LATERAL 派生表lateral_derived_table · critical · pendingLIMIT offset, count 逗号写法limit_comma_syntax · minor · professionalLOAD DATA [LOCAL] INFILE 批量装载load_data_infile · major · pendingMySQL LOAD_FILE 函数load_file_func · critical · pendingLOCK TABLES / UNLOCK TABLESlock_tables · major · pendingMySQL MASTER_POS_WAIT 复制等待master_pos_wait_func · blocker · pendingMySQL MEDIUMINT 类型mediumint_type · major · pendingMySQL 多值索引multi_valued_index · critical · pendingAES_ENCRYPT/AES_DECRYPT 密文兼容mysql_aes_crypto · blocker · pendingMySQL Enterprise 非对称加密函数族mysql_asymmetric_crypto · blocker · pendingFROM_BASE64/TO_BASE64 编码细节mysql_base64_functions · major · professionalBIN/BIT_COUNT 位字符串辅助函数mysql_bit_string_helpers · major · pendingMySQL 位异或 ^mysql_bitwise_xor · major · pendingMySQL BLOB 基础类型mysql_blob_type · major · professionalMySQL BOOLEAN/BOOL 类型mysql_boolean_type · minor · professionalMySQL 逻辑 XORmysql_boolean_xor · major · pendingDAY/DAYOFWEEK/DAYOFYEAR 日序函数族mysql_calendar_day_functions · critical · pendingLCASE/UCASE 大小写别名mysql_case_alias_functions · major · pendingCHAR 数值序列转字符mysql_char_code_function · critical · professionalMySQL CHAR/VARCHAR 类型mysql_character_types · minor · professionalCOMPRESS/UNCOMPRESS 二进制格式mysql_compression_functions · critical · pendingMySQL CONCAT 函数mysql_concat_function · major · pendingCONCAT_WS 分隔拼接的 NULL 语义mysql_concat_ws_function · major · pendingCONNECTION_ID/USER/SYSTEM_USER 会话身份mysql_connection_identity_functions · critical · pendingMySQL CONVERT_TZ 时区转换mysql_convert_timezone · critical · pendingCREATE TABLE ... LIKE 克隆表结构mysql_create_table_like · major · pendingMySQL CURDATE 函数mysql_curdate_function · major · pendingMySQL DATABASE/SCHEMA 当前库函数mysql_current_database_function · major · pendingCURTIME/SYSDATE 当前时间语义mysql_current_time_functions · critical · pendingDAYNAME/MONTHNAME 本地化名称mysql_date_name_functions · major · pendingMySQL DATE 类型mysql_date_type · minor · professionalDATEDIFF 整日边界差mysql_datediff_function · critical · professionalDELETE IGNORE 错误降级mysql_delete_ignore · critical · pendingDELETE ORDER BY / LIMITmysql_delete_order_limit · major · pendingMySQL 除法零除语义mysql_division_by_zero_semantics · critical · pendingMySQL bare DOUBLE 类型别名mysql_double_alias · major · professionalFIELD/ELT 位置与取值函数mysql_field_elt_functions · major · pendingFIND_IN_SET 逗号集合查找mysql_find_in_set · critical · pendingMySQL FIXED 定点数别名mysql_fixed_alias · minor · professionalGROUP BY 后缀式 WITH ROLLUPmysql_group_by_with_rollup · major · pendingHEX/UNHEX 二进制与文本转换mysql_hex_functions · critical · professionalMySQL 索引 USING HASH/BTREE/RTREEmysql_index_type_clause · major · pendingDIV 整数除法运算符mysql_integer_division_operator · major · pendingINET6/IPv4 兼容地址函数族mysql_ip_address_functions · critical · pendingMySQL ISNULL 函数mysql_isnull_predicate · major · pendingDES/ENCODE/ENCRYPT/OLD_PASSWORD 遗留密码函数mysql_legacy_crypto · blocker · pendingMySQL LENGTH 字节长度语义mysql_length_byte_semantics · critical · pendingLOCATE 子串位置与起始偏移mysql_locate_function · major · professionalLOG/LOG2/LOG10 底数差异mysql_logarithm_functions · critical · professionalMAKEDATE 年+日序构造日期mysql_makedate_function · major · pendingMySQL MAKETIME 时长/时间构造mysql_maketime_duration · major · pendingMID 子串别名mysql_mid_function · major · pendingMySQL 取模零除语义mysql_modulo_zero_semantics · critical · pendingMySQL 多表 DELETEmysql_multi_table_delete · critical · pendingMySQL 多表 UPDATEmysql_multi_table_update · critical · pendingMySQL NULL 安全等号 <=>mysql_null_safe_equality · major · pendingMySQL TRUNCATE 数值截断函数mysql_numeric_truncate · minor · pending/*+ ... */ 优化器提示(MySQL 8.0 风格)mysql_optimizer_hint · minor · pendingORD 多字节首字符数值mysql_ord_function · critical · pendingPERIOD_ADD/PERIOD_DIFF 年月编码运算mysql_period_arithmetic · critical · pendingMySQL || 受 PIPES_AS_CONCAT 影响mysql_pipes_sql_mode · critical · pendingMySQL POINT 空间类型mysql_point_type · critical · professionalMySQL 字符列前缀索引mysql_prefix_index · major · pendingQUOTE SQL 字面量转义mysql_quote_function · blocker · pendingRANDOM_BYTES 密码随机字节mysql_random_bytes · critical · pendingMySQL REGEXP_* 正则函数族mysql_regexp_functions · major · professionalMySQL REGEXP/RLIKE 操作符mysql_regexp_operator · major · pendingGTID 集合与复制等待函数mysql_replication_control_functions · blocker · pendingROW_COUNT 上一语句影响行数mysql_row_count_function · critical · pendingSHA/SHA1/SHA2 哈希函数返回格式mysql_sha_hash_functions · critical · professionalSLEEP 数据库会话阻塞mysql_sleep_function · critical · pendingSOUNDS LIKE 英文语音比较mysql_sounds_like · major · pendingSPACE 重复空格函数mysql_space_function · minor · pendingMySQL 标准整数类型mysql_standard_integer_types · minor · professionalSTRCMP 三值字符串比较mysql_strcmp_function · critical · pendingMySQL TEXT 基础类型mysql_text_type · minor · professionalADDTIME/SUBTIME/TIMEDIFF 时间算术mysql_time_arithmetic_functions · critical · pendingSEC_TO_TIME/TIME_TO_SEC 时长换算mysql_time_seconds_functions · critical · pendingMySQL TIME 类型mysql_time_type · major · professionalTIMESTAMPADD/TIMESTAMPDIFF 单位截断语义mysql_timestamp_interval_functions · blocker · professionalMySQL 有符号 TINYINT 类型mysql_tinyint_type · major · professionalUPDATE IGNORE 错误降级mysql_update_ignore · critical · pendingUPDATE ORDER BY / LIMITmysql_update_order_limit · major · pendingUTC_DATE/UTC_TIME/UTC_TIMESTAMP 时钟函数mysql_utc_clock_functions · critical · professionalMySQL UUID 函数mysql_uuid_function · major · pendingUUID_SHORT 64 位拓扑相关标识mysql_uuid_short · blocker · pendingVALIDATE_PASSWORD_STRENGTH 组件函数mysql_validate_password_strength · critical · pendingMySQL VIEW 定义mysql_view_definition · major · pendingWEEK/WEEKOFYEAR/WEEKDAY 周序模式mysql_week_functions · blocker · pendingWEIGHT_STRING/COLLATION 排序权重依赖mysql_weight_collation_functions · blocker · pendingMySQL 兼容检查:ALIAS LEN OVERoma.mysql.alias-len-over · major · professionalMySQL 兼容检查:AUTOINC INT WIDENoma.mysql.autoinc-int-widen · info · professionalMySQL 兼容检查:CHAR LENGTH OVERoma.mysql.char-length-over · critical · professionalMySQL 兼容检查:CHARSET UNSUPPORTEDoma.mysql.charset-unsupported · critical · professionalMySQL 兼容检查:COL NAME FROM KEYWORDoma.mysql.col-name-from-keyword · critical · professionalMySQL 兼容检查:COLLATION UNSUPPORTEDoma.mysql.collation-unsupported · critical · professionalMySQL 兼容检查:COLTYPE JSONoma.mysql.coltype-json · critical · professionalMySQL 兼容检查:COLTYPE POINToma.mysql.coltype-point · critical · professionalMySQL 兼容检查:COLUMN COUNT OVERoma.mysql.column-count-over · critical · professionalMySQL 兼容检查:COLUMN TOTAL LEN OVERoma.mysql.column-total-len-over · critical · professionalMySQL 兼容检查:COLUMNNAME LEN OVERoma.mysql.columnname-len-over · critical · professionalMySQL 兼容检查:DB2 ANCHOR TYPEoma.mysql.db2-anchor-type · critical · professionalMySQL 兼容检查:DB2 ARGUMENT COUNToma.mysql.db2-argument-count · critical · professionalMySQL 兼容检查:DB2 ARRAY TYPEoma.mysql.db2-array-type · critical · professionalMySQL 兼容检查:DB2 BEGIN ATOMIComa.mysql.db2-begin-atomic · critical · professionalMySQL 兼容检查:DB2 COPY OPTIONoma.mysql.db2-copy-option · critical · professionalMySQL 兼容检查:DB2 CREATE OF TYPEoma.mysql.db2-create-of-type · critical · professionalMySQL 兼容检查:DB2 CURSOR TYPEoma.mysql.db2-cursor-type · critical · professionalMySQL 兼容检查:DB2 DATA CAPTUREoma.mysql.db2-data-capture · critical · professionalMySQL 兼容检查:DB2 DATATYPEoma.mysql.db2-datatype · critical · professionalMySQL 兼容检查:DB2 EXECUTE IMMEDIATEoma.mysql.db2-execute-immediate · critical · professionalMySQL 兼容检查:DB2 EXTERNAL PROComa.mysql.db2-external-proc · critical · professionalMySQL 兼容检查:DB2 EXTERNAL SCALAR FUNComa.mysql.db2-external-scalar-func · critical · professionalMySQL 兼容检查:DB2 FOR ASoma.mysql.db2-for-as · critical · professionalMySQL 兼容检查:DB2 FUNC OPTIONoma.mysql.db2-func-option · critical · professionalMySQL 兼容检查:DB2 GET DIAGNOSTICSoma.mysql.db2-get-diagnostics · critical · professionalMySQL 兼容检查:DB2 INDEX INCLUDEoma.mysql.db2-index-include · critical · professionalMySQL 兼容检查:DB2 INDEX OPTIONoma.mysql.db2-index-option · critical · professionalMySQL 兼容检查:DB2 INDEX TABLESPACEoma.mysql.db2-index-tablespace · critical · professionalMySQL 兼容检查:DB2 LOB OPTIONoma.mysql.db2-lob-option · critical · professionalMySQL 兼容检查:DB2 MATERIALIZEDoma.mysql.db2-materialized · critical · professionalMySQL 兼容检查:DB2 MERGE INTOoma.mysql.db2-merge-into · critical · professionalMySQL 兼容检查:DB2 NAMED FUNCTIONoma.mysql.db2-named-function · critical · professionalMySQL 兼容检查:DB2 OPTIONS POLICYoma.mysql.db2-options-policy · critical · professionalMySQL 兼容检查:DB2 OVERLAPSoma.mysql.db2-overlaps · critical · professionalMySQL 兼容检查:DB2 PARAM DEFAULToma.mysql.db2-param-default · critical · professionalMySQL 兼容检查:DB2 PARAM INOUToma.mysql.db2-param-inout · critical · professionalMySQL 兼容检查:DB2 PERIOD TABLEoma.mysql.db2-period-table · critical · professionalMySQL 兼容检查:DB2 QUERY OPTIMIZEoma.mysql.db2-query-optimize · critical · professionalMySQL 兼容检查:DB2 RANDOM SORToma.mysql.db2-random-sort · critical · professionalMySQL 兼容检查:DB2 RETURNS ROWoma.mysql.db2-returns-row · critical · professionalMySQL 兼容检查:DB2 RETURNS TABLEoma.mysql.db2-returns-table · critical · professionalMySQL 兼容检查:DB2 SECURITY POLICYoma.mysql.db2-security-policy · critical · professionalMySQL 兼容检查:DB2 SEQ AS TYPEoma.mysql.db2-seq-as-type · critical · professionalMySQL 兼容检查:DB2 SEQ OPTIONoma.mysql.db2-seq-option · critical · professionalMySQL 兼容检查:DB2 SOURCE PROComa.mysql.db2-source-proc · critical · professionalMySQL 兼容检查:DB2 SOURCED TEMPLATE FUNComa.mysql.db2-sourced-template-func · critical · professionalMySQL 兼容检查:DB2 STAGING TABLEoma.mysql.db2-staging-table · critical · professionalMySQL 兼容检查:DB2 TABLE OPTIONoma.mysql.db2-table-option · critical · professionalMySQL 兼容检查:DB2 TRIGGER INSTEAD OFoma.mysql.db2-trigger-instead-of · critical · professionalMySQL 兼容检查:DB2 TRIGGER NO CASCADEoma.mysql.db2-trigger-no-cascade · critical · professionalMySQL 兼容检查:DB2 TRIGGER REFERENCINGoma.mysql.db2-trigger-referencing · critical · professionalMySQL 兼容检查:DB2 TRIGGER SECUREDoma.mysql.db2-trigger-secured · critical · professionalMySQL 兼容检查:DB2 TRIGGER UPDATE OFoma.mysql.db2-trigger-update-of · critical · professionalMySQL 兼容检查:DB2 TRIGGER WHENoma.mysql.db2-trigger-when · critical · professionalMySQL 兼容检查:DB2 USER DEFINED TYPEoma.mysql.db2-user-defined-type · critical · professionalMySQL 兼容检查:DB2 VIEW OF TYPEoma.mysql.db2-view-of-type · critical · professionalMySQL 兼容检查:DB2 VIEW WITH OPTIONoma.mysql.db2-view-with-option · critical · professionalMySQL 兼容检查:DB2 WITH NO DATAoma.mysql.db2-with-no-data · critical · professionalMySQL 兼容检查:DBNAME LEN OVERoma.mysql.dbname-len-over · critical · professionalMySQL 兼容检查:DELETE NO WHEREoma.mysql.delete-no-where · minor · professionalMySQL 兼容检查:DRDS BROADCASToma.mysql.drds-broadcast · critical · professionalMySQL 兼容检查:DRDS NON HASH PARTITIONoma.mysql.drds-non-hash-partition · major · professionalMySQL 兼容检查:ENCRYPTION OPTIONoma.mysql.encryption-option · critical · professionalMySQL 兼容检查:FN DATETIMEoma.mysql.fn-datetime · critical · professionalMySQL 兼容检查:FN ENCRYPTIONoma.mysql.fn-encryption · critical · professionalMySQL 兼容检查:FN GIS ACCESSORSoma.mysql.fn-gis-accessors · critical · professionalMySQL 兼容检查:FN GIS CONSTRUCTORSoma.mysql.fn-gis-constructors · critical · professionalMySQL 兼容检查:FN GIS FORMAToma.mysql.fn-gis-format · critical · professionalMySQL 兼容检查:FN GIS RELATIONSoma.mysql.fn-gis-relations · critical · professionalMySQL 兼容检查:FN INFORMATIONoma.mysql.fn-information · critical · professionalMySQL 兼容检查:FN MATHEMATICALoma.mysql.fn-mathematical · critical · professionalMySQL 兼容检查:FN OTHERoma.mysql.fn-other · critical · professionalMySQL 兼容检查:FN REPLICATION GTIDoma.mysql.fn-replication-gtid · critical · professionalMySQL 兼容检查:FN STRINGoma.mysql.fn-string · critical · professionalMySQL 兼容检查:FN SUM AGGREGATEoma.mysql.fn-sum-aggregate · critical · professionalMySQL 兼容检查:FUNC DEFINER AT SIGNoma.mysql.func-definer-at-sign · major · professionalMySQL 兼容检查:GET DIAGNOSTICS CONDITIONoma.mysql.get-diagnostics-condition · critical · professionalMySQL 兼容检查:GIS LITERAL MULTIPOLYGONoma.mysql.gis-literal-multipolygon · critical · professionalMySQL 兼容检查:GIS LITERAL POLYGONoma.mysql.gis-literal-polygon · critical · professionalMySQL 兼容检查:GLOBAL SECONDARY INDEXoma.mysql.global-secondary-index · major · professionalMySQL 兼容检查:INDEX COLUMN COUNT OVERoma.mysql.index-column-count-over · critical · professionalMySQL 兼容检查:INDEX COUNT OVERoma.mysql.index-count-over · critical · professionalMySQL 兼容检查:INDEX LENGTH OVERoma.mysql.index-length-over · critical · professionalMySQL 兼容检查:INDEX SINGLE COL LEN OVERoma.mysql.index-single-col-len-over · critical · professionalMySQL 兼容检查:INDEXNAME LEN OVERoma.mysql.indexname-len-over · critical · professionalMySQL 兼容检查:JOIN COUNT MAXoma.mysql.join-count-max · minor · professionalMySQL 兼容检查:KEY BLOCK SIZEoma.mysql.key-block-size · major · professionalMySQL 兼容检查:LOAD XMLoma.mysql.load-xml · critical · professionalMySQL 兼容检查:MARIADB NAMED FUNCTIONoma.mysql.mariadb-named-function · critical · professionalMySQL 兼容检查:NATURAL JOINoma.mysql.natural-join · critical · professionalMySQL 兼容检查:NVARCHAR PROC PARAMoma.mysql.nvarchar-proc-param · critical · professionalMySQL 兼容检查:PARTITION COUNT OVERoma.mysql.partition-count-over · critical · professionalMySQL 兼容检查:PK COLUMN COUNT OVERoma.mysql.pk-column-count-over · critical · professionalMySQL 兼容检查:PK LENGTH OVERoma.mysql.pk-length-over · critical · professionalMySQL 兼容检查:PL SYSTEM KEYWORDoma.mysql.pl-system-keyword · critical · professionalMySQL 兼容检查:PROC DEFINER AT SIGNoma.mysql.proc-definer-at-sign · major · professionalMySQL 兼容检查:RLIKE REGEXPoma.mysql.rlike-regexp · critical · professionalMySQL 兼容检查:SELECT NO WHEREoma.mysql.select-no-where · minor · professionalMySQL 兼容检查:SEQUENCEoma.mysql.sequence · critical · professionalMySQL 兼容检查:STORAGE ENGINEoma.mysql.storage-engine · critical · professionalMySQL 兼容检查:SUBQUERY IN WHILEoma.mysql.subquery-in-while · critical · professionalMySQL 兼容检查:TABLENAME LEN OVERoma.mysql.tablename-len-over · critical · professionalMySQL 兼容检查:UPDATE NO WHEREoma.mysql.update-no-where · minor · professionalMySQL 兼容检查:VARCHAR LENGTH OVERoma.mysql.varchar-length-over · critical · professionalMySQL 兼容检查:VIEW ALGORITHMoma.mysql.view-algorithm · major · professionalMySQL 兼容检查:VIEW DEFINERoma.mysql.view-definer · major · professionalMySQL 兼容检查:VIEW SQL SECURITYoma.mysql.view-sql-security · major · professionalMySQL 兼容检查:VIEWNAME LEN OVERoma.mysql.viewname-len-over · critical · professionalMySQL 兼容检查:WITH AS CTEoma.mysql.with-as-cte · critical · professionalINSERT ... ON DUPLICATE KEY UPDATEon_duplicate_key · major · pendingON UPDATE CURRENT_TIMESTAMP 自动更新时间戳on_update_current_timestamp · major · pendingOPTIMIZE TABLE 管理语句optimize_table · major · pendingPARTITION BY RANGE 分区表partition_by_range · minor · pendingCHECK/ANALYZE PARTITIONpartition_check_analyze · major · pendingEXCHANGE PARTITION 分区交换partition_exchange · critical · pendingPARTITION BY HASH / KEY / LIST 分区partition_hash_list_key · minor · pendingIMPORT/DISCARD PARTITIONpartition_import_discard · critical · pending显式分区选择(FROM t PARTITION (p))partition_selection · minor · pendingMySQL 子分区partition_subpartition · critical · pendingMySQL SQL 治理检查:ADVICE ONLINE MIGRATIONperf_static_risk.bb.mysql.advice_online_migration · major · professionalMySQL SQL 治理检查:BUILTIN PRIOR BACKUP CHECKperf_static_risk.bb.mysql.builtin_prior_backup_check · major · professionalMySQL SQL 治理检查:BUILTIN WALK THROUGH CHECKperf_static_risk.bb.mysql.builtin_walk_through_check · major · professionalMySQL SQL 治理检查:COLUMN AUTO INCREMENT INITIAL VALUEperf_static_risk.bb.mysql.column_auto_increment_initial_value · major · professionalMySQL SQL 治理检查:COLUMN AUTO INCREMENT MUST INTEGERperf_static_risk.bb.mysql.column_auto_increment_must_integer · major · professionalMySQL SQL 治理检查:COLUMN AUTO INCREMENT MUST UNSIGNEDperf_static_risk.bb.mysql.column_auto_increment_must_unsigned · major · professionalMySQL SQL 治理检查:COLUMN COMMENTperf_static_risk.bb.mysql.column_comment · major · professionalMySQL SQL 治理检查:COLUMN CURRENT TIME COUNT LIMITperf_static_risk.bb.mysql.column_current_time_count_limit · major · professionalMySQL SQL 治理检查:COLUMN DISALLOW CHANGEperf_static_risk.bb.mysql.column_disallow_change · major · professionalMySQL SQL 治理检查:COLUMN DISALLOW CHANGE TYPEperf_static_risk.bb.mysql.column_disallow_change_type · major · professionalMySQL SQL 治理检查:COLUMN DISALLOW CHANGING ORDERperf_static_risk.bb.mysql.column_disallow_changing_order · major · professionalMySQL SQL 治理检查:COLUMN DISALLOW DROPperf_static_risk.bb.mysql.column_disallow_drop · major · professionalMySQL SQL 治理检查:COLUMN DISALLOW DROP IN INDEXperf_static_risk.bb.mysql.column_disallow_drop_in_index · major · professionalMySQL SQL 治理检查:COLUMN DISALLOW SET CHARSETperf_static_risk.bb.mysql.column_disallow_set_charset · major · professionalMySQL SQL 治理检查:COLUMN MAXIMUM CHARACTER LENGTHperf_static_risk.bb.mysql.column_maximum_character_length · major · professionalMySQL SQL 治理检查:COLUMN MAXIMUM VARCHAR LENGTHperf_static_risk.bb.mysql.column_maximum_varchar_length · major · professionalMySQL SQL 治理检查:COLUMN NO NULLperf_static_risk.bb.mysql.column_no_null · major · professionalMySQL SQL 治理检查:COLUMN REQUIRE CHARSETperf_static_risk.bb.mysql.column_require_charset · major · professionalMySQL SQL 治理检查:COLUMN REQUIRE COLLATIONperf_static_risk.bb.mysql.column_require_collation · major · professionalMySQL SQL 治理检查:COLUMN REQUIRE DEFAULTperf_static_risk.bb.mysql.column_require_default · major · professionalMySQL SQL 治理检查:COLUMN REQUIREDperf_static_risk.bb.mysql.column_required · major · professionalMySQL SQL 治理检查:COLUMN SET DEFAULT FOR NOT NULLperf_static_risk.bb.mysql.column_set_default_for_not_null · major · professionalMySQL SQL 治理检查:COLUMN TYPE DISALLOW LISTperf_static_risk.bb.mysql.column_type_disallow_list · major · professionalMySQL SQL 治理检查:DATABASE DROP EMPTY DATABASEperf_static_risk.bb.mysql.database_drop_empty_database · major · professionalMySQL SQL 治理检查:ENGINE MYSQL USE INNODBperf_static_risk.bb.mysql.engine_mysql_use_innodb · major · professionalMySQL SQL 治理检查:INDEX KEY NUMBER LIMITperf_static_risk.bb.mysql.index_key_number_limit · major · professionalMySQL SQL 治理检查:INDEX NO DUPLICATE COLUMNperf_static_risk.bb.mysql.index_no_duplicate_column · major · professionalMySQL SQL 治理检查:INDEX PK TYPE LIMITperf_static_risk.bb.mysql.index_pk_type_limit · major · professionalMySQL SQL 治理检查:INDEX PRIMARY KEY TYPE ALLOWLISTperf_static_risk.bb.mysql.index_primary_key_type_allowlist · major · professionalMySQL SQL 治理检查:INDEX TOTAL NUMBER LIMITperf_static_risk.bb.mysql.index_total_number_limit · major · professionalMySQL SQL 治理检查:INDEX TYPE ALLOW LISTperf_static_risk.bb.mysql.index_type_allow_list · major · professionalMySQL SQL 治理检查:INDEX TYPE NO BLOBperf_static_risk.bb.mysql.index_type_no_blob · major · professionalMySQL SQL 治理检查:NAMING COLUMNperf_static_risk.bb.mysql.naming_column · major · professionalMySQL SQL 治理检查:NAMING COLUMN AUTO INCREMENTperf_static_risk.bb.mysql.naming_column_auto_increment · major · professionalMySQL SQL 治理检查:NAMING IDENTIFIER NO KEYWORDperf_static_risk.bb.mysql.naming_identifier_no_keyword · major · professionalMySQL SQL 治理检查:NAMING INDEX FKperf_static_risk.bb.mysql.naming_index_fk · major · professionalMySQL SQL 治理检查:NAMING INDEX IDXperf_static_risk.bb.mysql.naming_index_idx · major · professionalMySQL SQL 治理检查:NAMING INDEX UKperf_static_risk.bb.mysql.naming_index_uk · major · professionalMySQL SQL 治理检查:NAMING TABLEperf_static_risk.bb.mysql.naming_table · major · professionalMySQL SQL 治理检查:SCHEMA BACKWARD COMPATIBILITYperf_static_risk.bb.mysql.schema_backward_compatibility · major · professionalMySQL SQL 治理检查:STATEMENT ADD COLUMN WITHOUT POSITIONperf_static_risk.bb.mysql.statement_add_column_without_position · major · professionalMySQL SQL 治理检查:STATEMENT AFFECTED ROW LIMITperf_static_risk.bb.mysql.statement_affected_row_limit · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW COMMITperf_static_risk.bb.mysql.statement_disallow_commit · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW LIMITperf_static_risk.bb.mysql.statement_disallow_limit · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW ORDER BYperf_static_risk.bb.mysql.statement_disallow_order_by · major · professionalMySQL SQL 治理检查:STATEMENT DISALLOW TRUNCATEperf_static_risk.bb.mysql.statement_disallow_truncate · major · professionalMySQL SQL 治理检查:STATEMENT DML DRY RUNperf_static_risk.bb.mysql.statement_dml_dry_run · major · professionalMySQL SQL 治理检查:STATEMENT INSERT DISALLOW ORDER BY RANDperf_static_risk.bb.mysql.statement_insert_disallow_order_by_rand · major · professionalMySQL SQL 治理检查:STATEMENT INSERT MUST SPECIFY COLUMNperf_static_risk.bb.mysql.statement_insert_must_specify_column · major · professionalMySQL SQL 治理检查:STATEMENT INSERT ROW LIMITperf_static_risk.bb.mysql.statement_insert_row_limit · major · professionalMySQL SQL 治理检查:STATEMENT MAX EXECUTION TIMEperf_static_risk.bb.mysql.statement_max_execution_time · major · professionalMySQL SQL 治理检查:STATEMENT MAXIMUM STATEMENTS IN TRANSACTIONperf_static_risk.bb.mysql.statement_maximum_statements_in_transaction · major · professionalMySQL SQL 治理检查:STATEMENT MERGE ALTER TABLEperf_static_risk.bb.mysql.statement_merge_alter_table · major · professionalMySQL SQL 治理检查:STATEMENT REQUIRE ALGORITHM OR LOCK OPTIONperf_static_risk.bb.mysql.statement_require_algorithm_or_lock_option · major · professionalMySQL SQL 治理检查:STATEMENT SELECT NO SELECT ALLperf_static_risk.bb.mysql.statement_select_no_select_all · major · professionalMySQL SQL 治理检查:STATEMENT WHERE DISALLOW FUNCTIONS AND CALCULATIONSperf_static_risk.bb.mysql.statement_where_disallow_functions_and_calculations · major · professionalMySQL SQL 治理检查:STATEMENT WHERE MAXIMUM LOGICAL OPERATOR COUNTperf_static_risk.bb.mysql.statement_where_maximum_logical_operator_count · major · professionalMySQL SQL 治理检查:STATEMENT WHERE NO EQUAL NULLperf_static_risk.bb.mysql.statement_where_no_equal_null · major · professionalMySQL SQL 治理检查:STATEMENT WHERE NO LEADING WILDCARD LIKEperf_static_risk.bb.mysql.statement_where_no_leading_wildcard_like · major · professionalMySQL SQL 治理检查:STATEMENT WHERE REQUIRE SELECTperf_static_risk.bb.mysql.statement_where_require_select · major · professionalMySQL SQL 治理检查:STATEMENT WHERE REQUIRE UPDATE DELETEperf_static_risk.bb.mysql.statement_where_require_update_delete · major · professionalMySQL SQL 治理检查:SYSTEM CHARSET ALLOWLISTperf_static_risk.bb.mysql.system_charset_allowlist · major · professionalMySQL SQL 治理检查:SYSTEM COLLATION ALLOWLISTperf_static_risk.bb.mysql.system_collation_allowlist · major · professionalMySQL SQL 治理检查:SYSTEM EVENT DISALLOW CREATEperf_static_risk.bb.mysql.system_event_disallow_create · major · professionalMySQL SQL 治理检查:SYSTEM FUNCTION DISALLOW CREATEperf_static_risk.bb.mysql.system_function_disallow_create · major · professionalMySQL SQL 治理检查:SYSTEM FUNCTION DISALLOWED LISTperf_static_risk.bb.mysql.system_function_disallowed_list · major · professionalMySQL SQL 治理检查:SYSTEM PROCEDURE DISALLOW CREATEperf_static_risk.bb.mysql.system_procedure_disallow_create · major · professionalMySQL SQL 治理检查:SYSTEM VIEW DISALLOW CREATEperf_static_risk.bb.mysql.system_view_disallow_create · major · professionalMySQL SQL 治理检查:TABLE COMMENTperf_static_risk.bb.mysql.table_comment · major · professionalMySQL SQL 治理检查:TABLE DISALLOW DDLperf_static_risk.bb.mysql.table_disallow_ddl · major · professionalMySQL SQL 治理检查:TABLE DISALLOW DMLperf_static_risk.bb.mysql.table_disallow_dml · major · professionalMySQL SQL 治理检查:TABLE DISALLOW PARTITIONperf_static_risk.bb.mysql.table_disallow_partition · major · professionalMySQL SQL 治理检查:TABLE DISALLOW SET CHARSETperf_static_risk.bb.mysql.table_disallow_set_charset · major · professionalMySQL SQL 治理检查:TABLE DISALLOW TRIGGERperf_static_risk.bb.mysql.table_disallow_trigger · major · professionalMySQL SQL 治理检查:TABLE DROP NAMING CONVENTIONperf_static_risk.bb.mysql.table_drop_naming_convention · major · professionalMySQL SQL 治理检查:TABLE LIMIT SIZEperf_static_risk.bb.mysql.table_limit_size · major · professionalMySQL SQL 治理检查:TABLE NO DUPLICATE INDEXperf_static_risk.bb.mysql.table_no_duplicate_index · major · professionalMySQL SQL 治理检查:TABLE NO FOREIGN KEYperf_static_risk.bb.mysql.table_no_foreign_key · major · professionalMySQL SQL 治理检查:TABLE REQUIRE CHARSETperf_static_risk.bb.mysql.table_require_charset · major · professionalMySQL SQL 治理检查:TABLE REQUIRE COLLATIONperf_static_risk.bb.mysql.table_require_collation · major · professionalMySQL SQL 治理检查:TABLE REQUIRE PKperf_static_risk.bb.mysql.table_require_pk · major · professionalMySQL SQL 治理检查:TABLE TEXT FIELDS TOTAL LENGTHperf_static_risk.bb.mysql.table_text_fields_total_length · major · professionalOceanBase SQL 治理检查:STATEMENT AFFECTED ROW LIMITperf_static_risk.bb.oceanbase.statement_affected_row_limit · major · professionalOceanBase SQL 治理检查:STATEMENT DISALLOW OFFLINE DDLperf_static_risk.bb.oceanbase.statement_disallow_offline_ddl · major · professionalOceanBase SQL 治理检查:STATEMENT INSERT ROW LIMITperf_static_risk.bb.oceanbase.statement_insert_row_limit · major · professionalperformance_schema 系统库访问performance_schema_access · major · pendingREPAIR TABLE 管理语句repair_table · major · pendingREPLACE INTO 语句replace_into · major · pendingSELECT ... FOR SHAREselect_for_share · critical · pending遗留 LOCK IN SHARE MODE 锁定读select_for_share.lock_in_share_mode · critical · pendingSELECT ... INTO OUTFILE / DUMPFILEselect_into_outfile · major · pendingSELECT ... INTO @用户变量select_into_user_variable · critical · pendingSET GLOBAL/SESSION 变量与 sql_modeset_session_variables · major · pendingSET 集合类型set_type · major · pendingSHOW 元数据语句show_statements · minor · pendingSIGNAL / RESIGNAL 抛出条件signal_resignal · major · pendingSELECT ... FOR UPDATE SKIP LOCKEDskip_locked · critical · pending空间类型与空间索引(GEOMETRY / SPATIAL INDEX)spatial_types · major · pendingSQL_CALC_FOUND_ROWS / FOUND_ROWS 分页计数sql_calc_found_rows · major · pending存储函数(CREATE FUNCTION)stored_function · major · pending存储过程(CREATE PROCEDURE)stored_procedure · major · pendingSTR_TO_DATE 函数str_to_date_func · minor · pendingSTRAIGHT_JOIN 连接顺序固定straight_join · minor · pendingSUBSTRING_INDEX 函数substring_index_func · minor · pending系统变量 @@var 读取system_variables · minor · pendingMySQL TABLESPACE DDLtablespace_ddl · major · pendingTINYTEXT/MEDIUMTEXT/LONGTEXT 与 BLOB 族text_blob_variants · minor · pendingTINYINT(1) 布尔惯用法tinyint1_bool · minor · pendingREAD UNCOMMITTED/SERIALIZABLE 隔离级别差异transaction_isolation_level · critical · pendingSET TRANSACTION READ ONLY 只读事务契约transaction_read_only_semantics · critical · pending触发器(CREATE TRIGGER)trigger · major · pendingUNIX_TIMESTAMP / FROM_UNIXTIME 函数unix_timestamp_funcs · minor · pendingUNSIGNED 无符号整数属性unsigned_int · major · pendingRR 下 UPDATE 子查询快照差异update_subquery_rr_snapshot · critical · pendingMySQL UpdateXML 函数updatexml_func · critical · pending用户变量 @varuser_variables · major · pendingMySQL XA 事务语句xa_statement · blocker · pendingMySQL YEAR 类型year_type · major · pendingMySQL 零日期字面量zero_date_literal · critical · pendingZEROFILL 补零显示属性zerofill · minor · pending