0

what is the difference between truncate and drop in mysql

hi..,

i want to delete table in mysql database...what is the major difference deleting mysql db tables using drop and

truncate command......

MariaDB Database MySQL Add a comment
owen
asked Mar 03 2017

Answer

0

If you use Drop command, it will remove a table or a database itself.

Whereas truncate will remove only the contents but the table still exists.

Add a comment
jagannatharumugam
asked Mar 03 2017
edited Oct 05 2018
Post your Answer