Question

求php+mysql一段代码

问题:
现在有两张数据表:A(access表),B(mysql表),现想从B表中将字段String_1,String_2,String_3,String_4下所有资料取出添加于A表的STR1,STR2,STR3,STR4中!请高手写个代码给我,,小弟感激不尽,
可以写的详细一点吗,,才刚刚学这个,,可以写完 全 过程 吗,

Answer 1

示例：
<?php
//连接mysql
mysql_connect("localhost","root","");
mysql_select_db("test");
//mysql_query("set names 'gbk'");
//连接access
$dbc=new com("adodb.connection");
$dbc->open("driver=microsoft access driver (*.mdb);dbq=".realpath("test.mdb"));
//转移数据
$rs = mysql_query("select String_1,String_2,String_3,String_4 from mysqlTable") or die(mysql_error());
while($row = mysql_fetch_assoc($rs)){
$query = sprintf("insert into accessTable(STR1,STR2,STR3,STR4) values('%s','%s','%s','%s')",
$row['String_1'],$row['String_2'],$row['String_3'],$row['String_4']);
@$dbc->execute($query);
}
$rs->close();
?>

Answer 2

insert into a(STR1,STR2,STR3,STR4)
select String_1,String_2,String_3,String_4 from B