What are the differences between drop a table and truncate
a table?
Answer Posted / sudha
Truncate Table - Truncate table is the combination of Drop
and Create. It [Truncate]can drop and recreate the table.
Delete - Delete will deletes all the data in the table and
structure of the table.
| Is This Answer Correct ? | 4 Yes | 20 No |
Post New Answer View All Answers
Is mysql from oracle?
What is the current version of mysql?
How to get the number of rows selected or affected by a sql statement?
Write a query to fetch common records between two tables using mysql?
How do I setup a mysql database?
How do I download a mysql community server?
Which is better mysql or mssql?
What is datadir?
What are the features of mysql?
What is mysql gpl?
How to do login in mysql with unix shell.
How do I install mysql on windows 10?
How do I install the latest mysql on ubuntu?
Can varchar be primary key?
What is the purpose of using timestamp data type?