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_mode set 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')) ...