智慧职教: 更新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
- 下列两个语句select [name] from book where bno in (select bno from borrow)和select [name] from book where exists ( select * from borrow where borrow.bno=book.bno) 查询结果相同。
- 查询被借阅过的图书,语句 SELECT name from book where( ) 的条件,下列哪[br][/br]一个不能实现. A: no =all (select bno from borrow) B: no =any (select bno from borrow) C: no in (select bno from borrow) D: exists (select * from borrow where bno=book.bno)
- 以下语句除了查询满足条件的记录,还显示()表的所有记录。SELECT Reader.*,Borrow.ReaderIDFROM Reader LEFT OUTER JOIN Borrow ON Reader.ReaderID=Borrow.ReaderID A: Reader B: Borrow C: book
- 以下语句从__个表中进行查询。(填数字)SELECT Reader. *,ReaderType.* FROM Reader, ReaderType where Reader.TypeID=ReaderType.TypeID