What are the differences between drop a table and truncate
a table?
Answer Posted / velmurugan
Drop - will Delete the table date as well as the table
structure.
Truncate - Will Delete the table data only. The table
structure will remains.
Is This Answer Correct ? | 71 Yes | 9 No |
Post New Answer View All Answers
How do I backup mysql database on linux?
How to create trigger in mysql workbench?
What happens if you no create privilege in a database?
What is 'mysqlshow'?
What is int unsigned?
Is mysql free for enterprise?
What is mysql ndb?
What is auto increment in mysql?
What is a trigger in mysql?
What is the command line end user interface - mysql?
What is mysql root?
Is pdo faster than mysqli?
what is the difference between gui testing and database testing? : Mysql dba
What is a procedure example?
What are the difference between now and current_date in mysql?