制作一个插入语句 - Make a single insert statement

Make a single insert statement

本文关键字：一个插入语句 | 更新日期: 2023-09-27

我有一个名为stock-sales的mysql表，它有3列，我想用一条语句插入数据。

"INSERT INTO  stock_sales (size) SELECT size FROM stock_avail WHERE id='5957';
"INSERT INTO  stock_sales (transactionid, date) VALUES ('$bill','$date')";

$sqlQuery = "INSERT INTO  stock_sales (size) SELECT size FROM stock_avail WHERE id='5957';";
$sqlQuery. = "INSERT INTO  stock_sales (transactionid, date) VALUES ('$bill','$date')";
mysqli_multi_query($con,$sqlQuery);

函数执行一个或多个查询数据库。查询用分号分隔。

有关更多信息，请单击Mysqli_Multi_Query-W3学校

尝试：

INSERT INTO  stock_sales (size, transactionid, date) 
    SELECT size, '$bill', '$date' 
    FROM stock_avail 
    WHERE id='5957'

或

INSERT INTO  stock_sales (transactionid, date, size) 
    VALUES ('$bill', '$date', (SELECT size FROM stock_avail WHERE id='5957'))