deAdmin的博客

-- 根据key分10个区alter table table_name partition by key(filed_name) partitions 10;-- 删除Key分区ALTER TABLE table_name remove PARTITIONING;-- 想知更多请阅读Mysql官方文档:https://dev.mysql.com/doc/refman/8.0/en/p...

SELECT @@GLOBAL.sql_modeset sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'mac 通过客户端修改 亲自测试有效，...

-- 多字段批量更新update table_name set field_name='hello world' where (field_1,field_2)in(('xxxxxxx','xxxxxxx'))--多字段批量查询select * from table_name where (field_1,field_2)in(('xxxxxxx','xxxxxxxx'))...