Updated on 2023-03-17 GMT+08:00

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";