INSERT INTO表名(名称) [英] INSERT INTO tablename(colnames)

问题描述

你好，

hello,

INSERT INTO tablename(select colnames from tablename)

，运行此查询时出现错误.

, when I run this query I get an error.

推荐答案

您遇到的错误是什么?

INSERT INTO语句的语法如下:

What is the error you are getting?

Syntax for INSERT INTO statement is as follows:

INSERT INTO destination_table (column1, column2, column3) from (select column1, column2, column3 from source table);

各个列类型应匹配.

Respective column types should match.

使用此语法

Use this syntax

INSERT INTO Table1 (FirstName, LastName)
SELECT FirstName, LastName
FROM Table2

阅读这些资源:

http://www.w3schools.com/sql/sql_select_into.asp [ http://msdn.microsoft.com/en-us/library/ms190750.aspx [ ^ ]

并考虑您的源表和目标表是相同的:-?

read these resources :

http://www.w3schools.com/sql/sql_select_into.asp[^]

http://msdn.microsoft.com/en-us/library/ms190750.aspx[^]

and consider that your source and destination table are the same :-?

这篇关于INSERT INTO表名(名称)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！