摘要：
1、从一个表中查询数据插入另一个表insert into table1 (imgurl,title,author,describes,postuser,posttime,modifytime,isrecycle) (SELECT imgurl,title,author,describes,postuser,posttime,modifytime,isrecycle FROM table1);2、百万级分页优化#一般语句SELECT * FROM table ORDER BY id LIMIT 1000000, 10; #优化1SELECT * FROM table WHERE id >= 阅读全文
