mysql数据库已经连接好,现在想要在oracle数据库里面抓取数据,然后写入mysql数据里面...请问如何操作
自己写的,但是无法写入mysql里面...<?php
require('conn.php'); //查询
$stmt = OCIParse($conn,"SELECT FID,FBH,FMC,FDJ,FGG,FZL,FTJ FROM T_CPZL");
OCIDefineByName($stmt,"FID",&$FID);
OCIDefineByName($stmt,"FBH",&$FBH);
OCIDefineByName($stmt,"FMC",&$FMC);
OCIDefineByName($stmt,"FDJ",&$FDJ);
OCIDefineByName($stmt,"FGG",&$FGG);
OCIDefineByName($stmt,"FZL",&$FZL);
OCIDefineByName($stmt,"FTJ",&$FTJ);
OCIExecute($stmt);
$sql="insert into jos_vm_product(fid,product_sku,product_name,product_url,product_length,product_weight,product_width) values ($FID,$FBH,$FMC,$FDJ,$FGG,$FZL,$FTJ)";//写入数据的sql语句
自己写的,但是无法写入mysql里面...<?php
require('conn.php'); //查询
$stmt = OCIParse($conn,"SELECT FID,FBH,FMC,FDJ,FGG,FZL,FTJ FROM T_CPZL");
OCIDefineByName($stmt,"FID",&$FID);
OCIDefineByName($stmt,"FBH",&$FBH);
OCIDefineByName($stmt,"FMC",&$FMC);
OCIDefineByName($stmt,"FDJ",&$FDJ);
OCIDefineByName($stmt,"FGG",&$FGG);
OCIDefineByName($stmt,"FZL",&$FZL);
OCIDefineByName($stmt,"FTJ",&$FTJ);
OCIExecute($stmt);
$sql="insert into jos_vm_product(fid,product_sku,product_name,product_url,product_length,product_weight,product_width) values ($FID,$FBH,$FMC,$FDJ,$FGG,$FZL,$FTJ)";//写入数据的sql语句
解决方案 »
- 排行榜的问题,上升及下降排名如何设置?
- 一个mysql数据库的问题
- mysql 自定义函数中 limit 后跟 变量 出现错误
- mysql中有没有类似于connect by这样的解决层递搜索的(如此例)(急)
- 关于MYSQL的数据导入问题
- 中文问题?
- 万分火急:怎么mysql innodb表的insert操作速度如此低?
- 请问mysql 4以上的能支持“存储过程”和“触发器"吗?
- mysql存储商城的出售商品用一个表还是多个表好?
- "tomcat+mysql+jive+win2000"为何无法正确显示“汉字”,希望各位多帮忙!!!
- 这个sql语句执行得不正确
- 求一条mysql语句,我如何能得到对应的值呢?
ociexecute($stmt);