DROP AND TRUNCATE TABLE COMMAND IN MySQL | MySQL Tutorials #droptable #truncate #sqltips #mysql

DROP TABLE:

The DROP TABLE command deletes the table structure along with all its data.
Syntax: DROP TABLE table_name;
Example: DROP TABLE users;

TRUNCATE TABLE:

The TRUNCATE TABLE command removes all the rows from a table,
but keeps the table structure intact.

Syntax: TRUNCATE TABLE table_name;
Example: TRUNCATE TABLE old_users;

Please watch complete video to understand it with example...!!!