13 lines
219 B
MySQL
13 lines
219 B
MySQL
|
-- name: CreateSaleOrderDetail :one
|
||
|
|
INSERT INTO sale_order_detail (
|
||
|
|
sale_order_id,
|
||
|
|
product_id,
|
||
|
|
product_name,
|
||
|
|
quantity,
|
||
|
|
sub_total,
|
||
|
|
product_price,
|
||
|
|
profit
|
||
|
|
) VALUES(
|
||
|
|
$1, $2, $3, $4, $5, $6, $7
|
||
|
|
)
|
||
|
|
RETURNING *;
|