How to use SQL to create a database

      CREATE DATABASE my_guitar_shop2;
      

      CREATE DATABASE IF NOT EXISTS my_guitar_shop2;
      

      USE my_guitar_shop2;
      

       DROP DATABASE my_guitar_shop2;
      

       DROP DATABASE IF EXISTS my_guitar_shop2;
      

Description

• You can use the CREATE DATABASE statement to create a database.
• You can use the USE statement to select a database.
• You can use the DROP DATABASE statement to drop a database.
• Warning You should never drop a production database without first consulting the DBA. In most cases, though, you won’t have the privilege to do that (see figure 17-10).