drop--> means table is delete ,not roll back, truncate-->

What are the differences between drop a table and truncate
a table?

Question Posted / ramavtar rajput

Answer Posted / ramavtar rajput

drop--> means table is delete ,not roll back,

truncate-->

Is This Answer Correct ?

18 Yes

11 No

Please Help Members By Posting Answers For Below Questions

How MySQL Optimizes DISTINCT?

1042

How will show all records containing the name "sonia" and the phone number '9876543210'

860

What tools available for managing mysql server?

951

change column name and make a unique column so we get no dupes.

913

Which datatype is used for email in mysql?

911

What is max connections in mysql?

879

What is the use of i-am-a-dummy flag in mysql?

954

Write a query to count the number of rows of a table in mysql.

890

How to include numeric values in sql statements?

946

What are the functions of commit and rollback statements?

946

What is a trigger? How you can create a trigger in mysql?

857

What is pdo :: fetch_assoc?

852

What is the maximum size of table in mysql?

958

Write a query to find duplicate rows in table?

857

How to calculate the difference between two time values?

916