A

Admin • 833K Points
Coach

Q. What does `TRUNCATE TABLE` do?

  • (A) Deletes table structure and data
  • (B) Deletes data only and resets identity
  • (C) Deletes only selected rows
  • (D) Clears only NULL values
  • Correct Answer - Option(B)
  • Views: 29
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

`TRUNCATE TABLE` removes all rows and resets any `AUTO_INCREMENT` counter.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.