insert into from
时间: 2023-09-21 13:09:50 浏览: 92
insert into from 是一个错误的语法,正确的语法是 insert into table_name select * from table_name2,它的作用是将 table_name2 中的数据插入到 table_name 中。在的例子中,insert into biz_dict(id,BIZ_TYPE,biz_value,biz_desc) select t1.id,t1.data_dictionary_type,t1.data_dictionary_value,t1.data_dictionary_desc from data_dictionary t1 where t1.data_dictionary_type='省份',将满足条件 t1.data_dictionary_type='省份' 的数据从 data_dictionary 表中的指定字段插入到 biz_dict 表中的指定字段。
在和的例子中,insert into 语句用于向表中插入数据,而不是从另一个表中复制数据。以为例,Insert into Table1 values('赵','asds','90') 将一行数据插入到 Table1 表中的指定字段。<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* [insert into from 是怎么用的?](https://blog.csdn.net/Ideality_hunter/article/details/54378801)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
- *2* *3* [select into 和 insert into from的区别](https://blog.csdn.net/zy943453722/article/details/72835840)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
[ .reference_list ]