WebDevelopersNotes logo

home-icon Home / MySQL / my sql tutorial – Dropping tables

my sql tutorial – Dropping tables

my sql tutorial - Dropping tables

To remove all entries from the table we can issue the DELETE statement without any conditions.

DELETE from employee_data;
Query OK, 0 rows affected (0.00 sec)

However, this does not delete the table. The table still remains, which you can check with SHOW TABLES;

mysql> SHOW TABLES;
+---------------------+
| Tables in employees |
+---------------------+
| employee_data       |
+---------------------+
1 rows in set (0.00 sec)

To delete the table, we issue a DROP table command.

DROP TABLE employee_data;
Query OK, 0 rows affected (0.01 sec)

Now, we won’t get this table in SHOW TABLES; listing

Sponsored Links

Your comments
Star icon IMPORTANT Have a question / problem? Click here to ask an expert.

Sponsored Links

Tips

How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]

Fact

McDonalds sold their last hamburger in Iceland in October 2006. The chain then closed shop in the country. The hamburger still exists at the Bus Hostel Reykjavik, Iceland and has a live online video feed. [more...]

We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy