What is the sql statement to delete the database?

SQL statements are: 1. Delete the database, "drop database database name" and "truncate table table name" statements; 2. Delete the table, "drop table table name" statement; 3. Delete data, "delete" "from table name where condition" statement.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

How to write the sql statement to delete the database

drop database database name--delete the database

drop table table name--delete the table

delete from Table name where condition - deleting data

truncate table table name is also used to delete the database. But it can cut the sequence. You will know this by comparing it with DELETE.

Related learning recommendations:mysql tutorial(video)

The above is the detailed content of What is the sql statement to delete the database?. For more information, please follow other related articles on the PHP Chinese website!