|
|
Tutorials
Mysql
|
Topic |
How to drop or delete Mysql tables Data?
|
|
Explanation |
MySQL Delete :
The DROP statement is used to delete one or more tables completely from a database.
The syntax is
DROP TABLE tbl_name
The following example deletes the student table.
mysql> drop table student;
Query OK, 0 rows affected (0.00 sec)
This query will permanently remove or delete mysql tables (student).
DROP TABLE query drops all fields in the table and deletes the table. Once the DROP TABLE statement is used, we cannot use that table. So, we should be careful with this statement.
|
| A Note |
MySQL is the most popular open source Relational database Management system (RDBMS). Being a open source anyone can use and change the software for their needs. Hope you enjoy this tutorial. We welcome your Valuable feedbacks or suggestions on this MySQL tutorial. This is a copyright content.
|
|
|
|
Home
Scripts
Tutorials
Images
Tools
Purchase
Snippets
