L linuxcrow Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-24 #1 两个表.字段完全相同. 如何一次就把表1中的一条记录放到表2里 SQL语句可以, 我用ado连,adoquery有什么方法可以做到吗?
Q qhchen77 Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-24 #2 adoquery.sql中写sql语句，不就行了。
D deyan Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-24 #3 insert into table2 select * from table1
C cbdiy Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-24 #5 insert into table2 (fields) select fields from table1
J jrq Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-24 #6 adoquery.close; adoquery.SQL. clear; adoquery.SQL.add(insert into table2 select * from table1); adoquery.ExecSQL;
adoquery.close; adoquery.SQL. clear; adoquery.SQL.add(insert into table2 select * from table1); adoquery.ExecSQL;
