Help Center/
MapReduce Service/
Component Operation Guide (LTS)/
Using ClickHouse/
Common ClickHouse SQL Syntax
Updated on 2025-03-17 GMT+08:00
Common ClickHouse SQL Syntax
- CREATE DATABASE: Creating a Database
- CREATE TABLE: Creating a Table
- INSERT INTO: Inserting Data into a Table
- DELETE: Lightweight Deleting Table Data
- SELECT: Querying Table Data
- ALTER TABLE: Modifying a Table Structure
- ALTER TABLE: Modifying Table Data
- DESC: Querying a Table Structure
- DROP: Deleting a Table
- SHOW: Displaying Information About Databases and Tables
- UPSERT: Writing Data
Parent topic: Using ClickHouse
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.