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
What is the full meaning of mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
Write a program using the select statement, while loop.
How to drop an existing index in mysql?
What is database engine in mysql?
What is the function of myisamchk?
How would concatenate strings in mysql?
Is mysql relational?
Explain about reporting services of MYSQL?
What is trigger in mysql?
What is striped backup
What is difference between mongodb and mysql?
How is data stored in mysql?
What is definer in mysql?
What is max connections in mysql?