• 2022-06-19
    若要删除book表中所有数据,以下语句正确的是( )。
    A: TRUNCATE TABLE book
    B: TRUNCATE book
    C: TRUNCATE FROM book
    D: TRUNCATE * TABLE book
  • A

    内容

    • 0

      若要删除book表中的所有数据,以下语句正确的是() A: DROP<br/>FROM book B: DROP<br/>TABLE book C: DELETE<br/>FROM book D: DELETE<br/>TABLE book

    • 1

      若要删除book表中所有数据,以下语句错误的是( )。(多选) A: drop * from book B: delete * from book C: drop table book D: delete from book

    • 2

      删除student表所有的记录,下列语句正确的是 A: DELETE FROM TABLE student; B: DELETE TABLE student; C: TRUNCATE TABLE student; D: TRUNCATE FROM TABLE student;

    • 3

      删除表中的所有记录() A: delete from表名 B: drop table表名 C: truncate from表名 D: truncate table表名

    • 4

      删除test表中所有数据的语句为 A: drop table test; B: delete table test; C: delete from test; D: truncate test;