多项选择题
BookStore数据库中有销售明细表OrderDetail(OrderCode,BookCode,Amount)在OrderDetail表中添加一条记录:“08110801”、0701、3。SQL语句:()
A.INSERT INTOOrderDetail(OrderCode,Amount,BookCode)VALUES(‘08110801’,3,’0701’)
B.INSERT INTOOrderDetail(OrderCode,Amount,BookCode)VALUES(‘08110801’,’0701’,3)
C.INSERT INTOOrderDetail(OrderCode,BookCode,Amount)VALUES(‘08110801’,’0701’,3)
D.INSERT INTOOrderDetailVALUES(‘08110801’,’0701’,3)
相关考题
-
单项选择题
BookStore数据库中有出版社表从Publisher表删除“群众出版社”。SQL语句:()
A.DELET Epublisher WHERE Publisher=‘群众出版社’
B.DELETE FROM Publisher WHERE Publisher=‘群众出版社’
C.DELETE FROM Publisher WHERE Publisher=群众出版社
D.DELETE Publisher WHERE Publisher=群众出版社 -
单项选择题
BookStore数据库中有出版社表将Publisher表中出版社代号(CustomerCode)为“01”的出版社联系电话(Telephone)修改为“010-79797979”。SQL语句:()
A.UPDATE PublisherSET Telephone=010-79797979 WHERE PublisherCode=01
B.UPDATE PublisherSET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’
C.UPDATE FROMPublisher SET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’
D.UPDATE Publisher Telephone=‘010-79797979’ WHERE PublisherCode=‘01 -
单项选择题
BookStore数据库中有出版社表在Publisher表中添加一条记录:“66”、“群众出版社”、“0321-76584391”。SQL语句:()
A.INSERT INTO Publisher VALUES(‘群众出版社’,’66’,’0321-76584391’)
B.INSERT INTO Publisher VALUES(‘群众出版社‘,66,’0321-76584391’)
C.INSERT INTO Publisher VALUES(‘66’,’群众出版社‘,’0321-76584391’)
D.INSERT Publisher VALUES(‘66’,’群众出版社‘,’0321-76584391’)
