数据库MYSQL
最近在学习←
菜鸟
展开
-
判断重复时间段判断
SELECT * FROM applet_big_event WHERE id !=9 and (start_time BETWEEN '2021-05-18 00:00:00' and '2021-05-21 00:00:00' or end_time BETWEEN '2021-05-18 00:00:00' and '2021-05-21 00:00:00' ) or (start_time<'2021-05-18 00:00:00' and end_time >'2021-...原创 2020-05-18 14:44:01 · 690 阅读 · 1 评论 -
msql扩大RAM即解决The total number of locks exceeds the lock table size
部分转载 :https://blog.csdn.net/github_36326955/article/details/54970808 Linux : ps -ef|grep mysql mysql -h主机地址 -u用户名-p用户密码 mysql -h localhost -uxxxxxxx-pxxxxxxx show variables like "%_buffer%";...原创 2019-09-17 14:43:10 · 145 阅读 · 0 评论