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.

Web browser funny images and jokes

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

Logitech was the first company to sell the modern computer mouse. The device with an optical encoder, two buttons and a single ball was created by Jean-Daniel Nicoud and André; Guignard of the Ecole Polytechnique Federale de Lausanne in Switzerland. Their mouse was a major improvement over the one created by Douglas Engelbart, the original creator of the mouse. Logitech's computer mouse was originally manufactured by Dubois Depraz SA, another Swiss company. From 1985 to 2008, the company sold a billion of these devices! [more...]

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