Shulou(Shulou.com)06/01 Report--

Mysql deletes the table from the command line

1. Syntax:

DROP TABLE IF EXISTS table name

two。 Syntax parsing:

DROP TABLE: delete table command

IF EXISTS: determine whether the table exists, if there is a table to delete the corresponding table, if there is no error to avoid execution

3. An example without an IF EXISTS statement:

Command: DROP TABLE cour

Screenshot:

4. An example of an IF EXISTS statement:

Command: DROP TABLE IF EXISTS cour

Screenshot:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.