以下语句从__个表中进行查询。（填数字）SELECT Reader. *,ReaderType.* FROM Reader, ReaderType where Reader.TypeID=ReaderType.TypeID
举一反三
- 以下语句表示_____连接。（填汉字）SELECT Reader.*,ReaderType.* FROM Reader INNER JOIN ReaderType ON Reader.TypeID=ReaderType.TypeID
- 智慧职教: 更新borrow表每条借书记录的eprdate(到期日期)。 borrow eprdate=timestampadd(day,(select maxdays from readertype where typeID in (select typeID from reader where reader.readerID=.)),brwdate);
- 删除ReaderType表中所有数据，正确的命令是 A: DELETE TABLE ReaderType B: DELETE ReaderType C: DROP TABLE ReaderType D: DROP ReaderType
- 往reader表中插入一个学生 ’2004060003’，’李亚茜’，3（ ）。 A: INSERT into ReaderVALUES('2004060003','李亚茜',3) B: INSERT into Reader(RID,Rname,TypeID)VALUES('2004060003','李亚茜',3) C: INSERT into Reader(RID,Rname,TypeID)VALUES('李亚茜','2004060003',3) D: INSERT into Reader(RID,TypeID,Rname)VALUES('2004060003','李亚茜',3)
- 以下语句除了查询满足条件的记录，还显示（）表的所有记录。SELECT Reader.*,Borrow.ReaderIDFROM Reader LEFT OUTER JOIN Borrow ON Reader.ReaderID=Borrow.ReaderID A: Reader B: Borrow C: book