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);