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
1 Like
Related Questions
Which of the following cannot be returned by random.randrange(4) ?
- 0
- 3
- 2.3
- None of these
Find errors (if any) in the following code and rewrite the code underlining each correction:
x = int("Enter value of x:") for in range[0, 10]: if x = y print("They are equal") else: Print("They are unequal")A computer or a device that requests resources or data from the server is called …………… .
The readlines() method returns …………… (a list of lines/a list of single characters).