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;

| 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.

Why we hate Internet Explorer?

Sponsored Links


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...]


JavaScript was initially called LiveScript. The final name change is generally regarded as a clever marketing stunt by Netscape to ride on the popularity of Java, the hot new language at that time. So though the names are similar, JavaScript and Java have little in common. The language was created by Brendan Eich when he was working at Netscape Communications Corporation and it was first included in the beta releases of Netscape Navigator 2.0. Actually, if we go a little further in time, the language was called "Mocha" during development! JavaScript is now one of the most popular languages on the web and the term has been trademarked by Oracle Corporation. In the early days, Microsoft's implementation of the language was JScript. [more...]

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