![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
-万里晴空-
这个作者很懒,什么都没留下…
展开
-
mysql 中的 case when then else end
select case c.name WHEN ‘一班’ THEN ‘ifelse’ else c.name end as name from class c;原创 2019-07-30 18:57:06 · 92 阅读 · 0 评论 -
mysql 杀死进程
show OPEN TABLES where In_use > 0;#查看下在锁的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;#查看当前锁定的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;#查看当前等锁的事务SELECT * FROM INFORMATION_SCHEMA.INNOD...原创 2019-09-27 15:26:56 · 1308 阅读 · 0 评论