1.多表查询与日期比较
select o.username,o.oid,o.allmoney,o.paytime,d.aid,d.bookcount,d.salePrice,b.isbn,b.bname,b.author,b.pubdate,b.press,b.price,b.descr,b.pic,b.bkaccount
from torder o,torderdetail d,tbook b
where o.oid = d.oid and b.isbn = d.isbn and o.paytime >= str_to_date('2017-10-14','%Y-%m-%d %H:%i:%s') order by aid limit 0 ,3;
2.连续增长
insert into torderdetail (aid,oid,isbn,bookcount,salePrice) values ((select IFNULL(max(t.aid),0)+1 from torderdetail t),66,'is001',5,5);
