Dropping Tables and Databases : Drop « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Drop

Dropping Tables and Databases

      
mysql>
mysql>
mysql> CREATE TABLE commission (id INT);
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE commission;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> CREATE DATABASE shortlived;
Query OK, 1 row affected (0.00 sec)

mysql> DROP DATABASE shortlived;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
    
  

Related examples in the same category