随笔分类 -  mysql

mysql not EXISTS 替代 not in
摘要：SELECT * FROM `table` a where EXISTS ( SELECT * FROM ( VALUES ROW(1), ROW(5), ROW(4), ROW(9999999)) as t where a.id=t.column_0 ) 由于有的时候会优化not in 但是值又都 阅读全文
posted @ 2022-03-23 17:07 野兽Gentleman 阅读(461) 评论(0) 推荐(0)
MySQL修改时区
摘要：set global time_zone = '+8:00'; flush privileges; 治标不治本 稍后研究 阅读全文
posted @ 2021-04-19 08:53 野兽Gentleman 阅读(51) 评论(0) 推荐(0)