Databases

In MySQL, DATABASE is a schema object, which is equivalent to the SCHEMA of Oracle and GaussDB(DWS). DSC supports the following two scenarios:

1. Database creation

   Input

   create database IF NOT EXISTS dbname1 CHARACTER SET=utf8 COLLATE=utf8_unicode_ci;
   create database IF NOT EXISTS dbname2;
   
   drop database if exists dbname1;
   drop database if exists dbname2;

   Output

   CREATE SCHEMA "dbname1";
   CREATE SCHEMA "dbname2";
   
   DROP SCHEMA IF EXISTS "dbname1";
   DROP SCHEMA IF EXISTS "dbname2";

2. Database use

   Input

   drop database if exists test;
   create database if not exists test;
   use test;

   Output

   DROP SCHEMA IF EXISTS "test";
   CREATE SCHEMA "test";
   SET CURRENT_SCHEMA = "test";