我想從一個表 ( oldDataTable) 中選擇一些列并插入到另一個表 ( newDataTable) 中。兩者都在同一個數據庫中。我試過了。如果我只選擇一列它的工作原理。但如果我選擇不止一列，則不會發生任何事情。oldDataTable 有像這樣的列Name | Date | Voltage | Current | Power | RMS.我只想選擇像這樣的列Name| Date| Power并將其插入到newDataTable. 當用戶提交表單按鈕時，我正在這樣做。請任何幫助。<?phpif (isset($_POST['submit'])){ include ("DBconnect.php"); $conn= mysqli_connect( $dbhost, $dbuser, $dbpass, $db ); if ($conn->connect_error){ die("Connection failed: " . $conn->connect_error); } else{ $insertNEQuery= "INSERT INTO newDataTable (Name, Date, Power) SELECT (Name, Date, Power) FROM oldDataTable WHERE ID = '2' "; //it should be a bunch of rows. I have data for every one minute. mysqli_query($conn, $insertNEQuery); echo " data updated!"; $conn->close(); }} else echo " please click submit button!";?>```
2 回答
慕姐4208626
TA貢獻1852條經驗 獲得超7個贊
中不需要括號SELECT，以下查詢將起作用。
INSERT INTO newDataTable (Name, Date, Power) SELECT Name, Date, Power FROM oldDataTable WHERE ID = '2'
所以你的代碼將是：
$insertNEQuery= "INSERT INTO newDataTable (Name, Date, Power) SELECT Name, Date, Power FROM oldDataTable WHERE ID = '2' ";
大話西游666
TA貢獻1817條經驗 獲得超14個贊
使用此查詢
INSERT INTO newDataTable (SELECT Name, Date, Power FROM oldDataTable WHERE ID = '2')";
- 2 回答
- 0 關注
- 276 瀏覽
添加回答
舉報
0/150
提交
取消