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...]
The world's first handheld commercially available mobile phone was Motorola's DynaTAC. It was priced at $3,995 upon release and had an LED display for dialling and recalling numbers. Martin Cooper of Motorola made the very first call from a cell phone using the DynaTAC on 3rd April 1973. [more...]
We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy