Question

access数据库如何执行insert into子查询插入

insert into tablename(info,name)values(select name from info where id=2),'name')
答案：
insert into tablename(info,name) select name,'name' from info where id=2

Answer 1

在使用INSERT INTO TableName(field1,field2,field3,....) VALUES(....)向Access数据库插入一条族型记录时，兆升猜总提示insert into 语句语法错误，解决该问题的方法笑磨是在field名称上加一方括号[],也就是：
INSERT INTO TableName([field1],[field2],[field3],....) VALUES(....)

Answer 2

insert into tablename(info,name) select name,'name'友毕 from info where id=2

就是局告凳桐旅这样

Answer 3

INSERT INTO [tablename]([info],[name])SELECT [info],[name] FROM [info] WHERE [id]=2