Databases

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

View PDF

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

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

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

Previous topic: Comments

Next topic: Data Manipulation Language (DML)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel