Home / MySQL / 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
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...]
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