# INSERT INTO
#### 功能描述
向表中添加一行或多行数据。
#### 血缘解析支持的语法格式
```
INSERT INTO/INSERT OVERWRITE INTO {schema_name}.{table_name}
```
#### 语句示例1
```
INSERT INTO mySchema.tbl_1(code, title) SELECT code, title FROM mySchema.tbl_2 WHERE date_prod < '2026-05-07';
```
#### 语句示例2
```
INSERT INTO mySchema.inner_order (region, product, product_units, product_sales) 
WITH 
regional_sales AS (SELECT region, SUM(amount) AS total_sales FROM mySchema.orders_1 GROUP BY region), 
top_regions AS (SELECT region FROM regional_sales WHERE total_sales > (SELECT SUM(total_sales)/10 FROM regional_sales))
SELECT region, product,SUM(quantity) AS product_units, SUM(amount) AS product_sales FROM mySchema.orders WHERE region IN(SELECT region FROM mySchema.top_regions) GROUP BY region, product;
```