是啊!关键是select * from PUB_GOODS_VARIETY a,ZX_CHL_NETSTOCK_DOC b,ZX_CHL_NETSTOCK_DTL c,PUB_GOODS_VARTYPE d where b.BUYBATCHID=c.BUYBATCHID and d.VARTYPEID=c.VARTYPEID and a.VARIETYID=d.VARIETYID and b.BUYBATCHID='".$BUYBATCHID."' and c.BUYBATCHID='".$BUYBATCHID."'"; 这句SQL语句取出来的值有418条,为什么用while 循环不能把它全部插入到pharmstock表呢
算了!我用INSERT INTO pharmstock(BUYBATCHID,VARTYPEID,BUYAMOUNT,UPPRICE,USERID) SELECT BUYBATCHID, VARTYPEID,BUYAMOUNT,UPPRICE,'".$user_id."' FROM ZX_CHL_NETSTOCK_DTL where BUYBATCHID=181;这句SQL取代了!不过我还真的想知道为什么前面这样循环写法不行!高手指点迷津!!!!
这句SQL语句取出来的值有418条,为什么用while 循环不能把它全部插入到pharmstock表呢