php - 如何转置 Mysql INSERT 语句？

Question

如何转置 INSERT 语句

目前，当我将数据插入表中时，看起来像这样。

但我想插入如下

 bomItem      partID
 600000      500000     
 600000      200000
 600000      100000
 600204      500210
 600204      201862
 600204      100202
 600206      500204
 600206      201748
 600206      100202
   .           .
   .           .
   .           .

我有以下代码将数据从一个数据库插入到另一个(Mysql)表

 $recordd = $tv->search(3000254898, 's=2');

 foreach($recordd as $data2) {
  $itemid = $data2['fields']['STOCK NO'];
  $bomwheel = $data2['fields']['BOM WHEEL PN'];
  $bomtire = $data2['fields']['BOM TIRE PN'];
  $bomvalve = $data2['fields']['BOM VALVE PN'];
  $result = mysqli_query($con,"INSERT INTO assy   (ItemID,bom1w,bom2t,bom3v) VALUES ($itemid, $bomwheel, $bomtire,$bomvalve)"); 
}

Answer 1

请尝试这种方式 3 分别插入，其中 $itemid 在所有情况下都相同:

foreach($recordd as $data2) {
   $itemid = $data2['fields']['STOCK NO'];
   $bomwheel = $data2['fields']['BOM WHEEL PN'];
   $bomtire = $data2['fields']['BOM TIRE PN'];
   $bomvalve = $data2['fields']['BOM VALVE PN'];
   mysqli_query($con,"INSERT INTO assy(ItemID,bom1w) VALUES($itemid, $bomwheel)");
   mysqli_query($con,"INSERT INTO assy(ItemID,bom2t) VALUES($itemid, $bomtire)");
   mysqli_query($con,"INSERT INTO assy(ItemID,bom3v) VALUES($itemid, $bomvalve)"); 
}