delphiÖÐÈçºÎ½«Ò»¸öaccess±íµÄÊý¾Ýµ¼Èëµ½ÁíÒ»¸ö±íÖУ¿

ллÁË¡£×îºÃÓдúÂë

---

Insert into Table2(field1,field2,...) select value1,value2,... from Table1

---

insert into ±íÒ» select * from ±í¶þ

Èç¹û×ֶβ»Ò»Ö£¬ÒªÖ¸¶¨×Ö¶Î

insert into ±íÒ»(A,B) select C,D from ±í¶þ

---

ͬһ¸öÊý¾Ý¿âÖÐ:
  with adoquery1 do
  begin
    close;
    sql.text := 'insert into tb select * from t1';
    ExecSql;
  end;
²»Í¬µÄÊý¾Ý¿âÖУ¬ÏȲéѯ£¬È»ºóÑ­»·insert.

---

Delphi(Pascal) code:

select * into table1 from table2
»òÕß
Insert into Table1(field1,field2,...) select value1,value2,... from Table2

---

ÍüÁË¡£ÎÒÏëÔÚdelphiÖÐдÕâЩ´úÂë¡£ÈçºÎдÄØ£¿¸ø¸öÀý×Ó×îºÃÁË