CREATE DATABASE
This section describes the basic SQL syntax and usage of the Doris database.
Basic Syntax
CREATE DATABASE [IF NOT EXISTS] db_name
[PROPERTIES ("key"="value", ...)];
Use Example
- Connect to Doris through MySQL client as a user with Doris administrator permissions.
- Run the following command to create the database example_db:
create database if not exists example_db;
- Run the following command to view the database information:
SHOW DATABASES;
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | example_db | | information_schema | +--------------------+ 2 rows in set (0.00 sec)
- Run the following command to switch to example_db:
use example_db;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.