Computer Science

Mr. William wants to remove all the rows from table INVENTORY to release the storage space but he does not want to remove the structure of the table. What MySQL statement should he use?

DDL & DML

1 Like

Answer

DELETE FROM INVENTORY;

This statement will delete all rows from the INVENTORY table, freeing up storage space, but it will not remove the structure or schema of the table.

Answered By

2 Likes


Related Questions