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 do you name a table?

842

What is pragma exception?

918

How to escape special characters in sql statements?

930

What is the use of mysqli_fetch_assoc?

861

How do you know the version of your mysql server?

1115

Is mysql same as mariadb?

865

How large can a mysql table be?

898

What is RMS Migrations

2358

What is information_schema in mysql?

942

What does mysql flush tables do?

919

What is flush privileges in mysql?

950

What data structure does mysql use?

956

using primary can we relate two table, with out foreign key?

2666

How do I change the max connections in mysql?

848

How do I assign a variable in mysql?

946