qq_35524189的博客

注：aaa是我定的过程名，bbb为事件名先看event 事件是否开启show variables like '%sche%';如没开启，则开启。需要数据库超级权限set global event_scheduler =1;创建存储过程CREATE DEFINER=`xxxx` PROCEDURE `aaa`()BEGIN #Routine body goes here... #example:UPDATE test_sche SET counts=counts+1 WHE

in的工作原理select * from A where id in(select id from B);完全先执行in内的子查询得到缓存整张表B，再执行select * from A 得到表A与缓存的整张B表内字段进行匹配，遍历整张A表后得到结果。过程如下Array A={select * from A};Array B={select id from B};for (int i=0;i<A.length;i++){ for (int j=0;j<B.length;j++