tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Configuration Change
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
문서TDSQL BoundlessGeneral ReferenceSQL ReferenceSQL StatementsCREATE DATABASE

CREATE DATABASE

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-02-10 11:25:37

Description

This statement is used to create a database and can specify the default attributes of the database (such as the default character set and collation rules).

Permission Requirements

To execute the CREATE DATABASE statement to create a database, users need to have the global CREATE permission.

Syntax

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] database_name
    [database_option] ...

database_option:
[DEFAULT] {CHARACTER SET | CHARSET} [=] charset_name
| [DEFAULT] COLLATE [=] collate_name

Parameter Description

Parameter
Optional or Not
Description
IF NOT EXISTS
Optional
Indicates that if the database already exists, it will not be created. When a database is created, if the database exists and no IF NOT EXISTS is specified, an error will be reported.
database_name
Required
Specifies the name of the database to be created.
[DEFAULT] {CHARACTER SET | CHARSET} [=] charset_name
Optional
Sets the character set (charset) of the database.
[DEFAULT] COLLATE [=] collate_name
Optional
Sets the collation rules of the database.

Examples

tdsql [(none)]> CREATE DATABASE IF NOT EXISTS test1 DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected
이전 주제: BATCH LIMIT다음 주제: CREATE PARTITION POLICY

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백