下列语句用来删除数据表中指定记录，正确的语句是（ ）。
A: DELETE FROM book WHERE 单价>20
B: DELETE * FROM book
C: DELETE FROM book HAVING 单价>20
D: DELETE FROM book
A: DELETE FROM book WHERE 单价>20
B: DELETE * FROM book
C: DELETE FROM book HAVING 单价>20
D: DELETE FROM book
举一反三
- 若要删除book表中所有数据,以下语句正确的是( )。 A: delete table book B: delete * from book C: drop book D: delete from book
- 下列语句用来删除表对象或表数据，其中不正确的语句是（）。 A: TRUNCATE TABLE book B: DELETE * FROM book C: DROP TABLE book D: DELETE FROM book
- 若要删除book表中所有数据,以下语句错误的是( )。(多选) A: drop * from book B: delete * from book C: drop table book D: delete from book
- 若要删除book表中的所有数据,以下语句正确的是() A: DROP<br/>FROM book B: DROP<br/>TABLE book C: DELETE<br/>FROM book D: DELETE<br/>TABLE book
- 若要删除book表中所有数据包含约束等，以下语句正确的是（）。 A: truncate table book B: delete * from book C: drop table book D: delete from table