Breaking News
yeni film izle hd film seyret film izle

Deleting Tables and Databases

Deleting Tables and Databases To delete a table entirely, use the DROP TABLE statement. Similarly, you can delete an entire database with DROP DATABASE .

Here, we will show you how to DROP TABLE

mysql > SHOW TABLES;

Output

Tables_in_mydatabase
Courses

1 row in set 

mysql > DROP TABLE Course;

Query OK, 0 rows affected

mysql > SHOW TABLES;

Empty set

DROP DATABASE works in a similar way

mysql > SHOW DATABASES;

Output

Database
information_schema
mydatabase
mysql

3 rows in set

mysql > DROP DATABASE mydatabase;

Query OK, 0 rows affected

mysql > SHOW DATABASES;

Output

Database
information_schema
mysql

2 rows in set

Check Also

Copying, Renaming, and Deleting Files

PHP also allows you to copy, rename, and delete files. The functions to perform these …