MySQL determines whether a database or table exists

(1) To determine the existence of the database, delete:

Drop database if exists db_name;
(2) to determine the existence of the data table, delete:

drop table if exists table_name;

NOTE: db_name, table_name can be used to "(1 keys next to the key) is caused by the number, also do not cause.

(1) If a simple display of the existence of a database, you can use show databases like ' Db_name ';(2) simply show if there is a data table, you can use show tables like ' table_name '; Note: db_name here, table_name must be caused by ' (single quote).

MySQL determines whether a database or table exists