摘要:
一、Event创建语法 CREATE Event [IF NOT EXISTS] event_name -- 创建使用create event ON SCHEDULE schedule -- on schedule 什么时候来执行,执行频率 [ON COMPLETION [NOT] PRESERVE 阅读全文
摘要:
同一表内UPDATE数据 mysql> select * from test1; + + + + + + + | id | a | b | c | d | e | + + + + + + + | 1 | 34 | 6 | 10 | 0 | 2 | | 2 | 22 | 5 | 22 | 0 | 5 阅读全文
摘要:
DELETE A FROM Table_name A JOIN (SELECT id FROM table_name ORDER BY id DESC LIMIT 10,1) B WHERE A.id<=B.id 阅读全文