智慧职教: 更新borrow表每条借书记录的eprdate(到期日期)。 borrow  eprdate=timestampadd(day,(select maxdays from readertype where typeID in (select typeID from reader where reader.readerID=.)),brwdate);

智慧职教: 创建视图，保存所有借书逾期者名单。代码如下:create  overduelistasselect reader.readerID,reader.name from reader where readerID  (select   from borrow where rtndate  null and eprdate