Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> MySQL Syntax Migration> Databases
View PDF

Databases

In MySQL, DATABASE is a schema object, which is equivalent to the SCHEMA concept in Oracle and GaussDB A. The following two scenarios are considered for DSC:

  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";
Parent topic: MySQL Syntax Migration