MySQL Tutorial

A database system used with PHP.

Chapter Quiz Exercises
Course Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views

MySQL Drop Table

MySQL DROP TABLE Statement

The DROP TABLE statement is used to drop an existing table in a database.

Syntax:

DROP TABLE table_name;

Note: Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!

TRUNCATE TABLE

The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.

Try It Yourself

Edit the code below and click Run to see the result live.

Source Code
Result
Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views