![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
iteye_3754
这个作者很懒,什么都没留下…
展开
-
mysql事件调度器
SHOW VARIABLES WHERE Variable_name = 'event_scheduler';#开启mysql事件调度器功能SET GLOBAL event_scheduler =1;原创 2014-04-13 12:29:23 · 63 阅读 · 0 评论 -
mysql的join
SELECT * FROM a LEFT JOIN b ON a.aID = b.bID; a为主,a的数据全显示,连不上b的对应字段为空 SELECT * FROM a RIGHT JOIN b ON a.aID = b.bID; b为主,b的数据全显示,连不上a的对应字段为空 SELECT * FROM a INNER JOIN a ON a.aID = b.bID; 相...原创 2014-04-13 12:29:34 · 65 阅读 · 0 评论