Help Center/
MapReduce Service/
Component Operation Guide (ME-Abu Dhabi Region)/
Using ClickHouse/
Common ClickHouse SQL Syntax/
INSERT INTO: Inserting Data into a Table
Updated on 2024-07-19 GMT+08:00
INSERT INTO: Inserting Data into a Table
This section describes the basic syntax and usage of the SQL statement for inserting data to a table in ClickHouse.
Basic Syntax
Example
-- Insert data into the test2 table. insert into test2 (id, name) values (1, 'abc'), (2, 'bbbb'); -- Query data in the test2 table. select * from test2; ┌─id─┬─name─┐ │ 1 │ abc │ │ 2 │ bbbb │ └───┴────┘
Parent topic: Common ClickHouse SQL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot