使用Mysql事务插入多个记录 [英] Insert multiple records using Mysql Transaction

问题描述

我需要你的帮助.我有一个项目，需要在表中插入多个记录.这里有更多细节.
我设计了一个采购订单表和purchaseorderdetails
采购订单
PURCHASE_ORDER_ID
PO_DATE
CLIENT_ID
采购订单详细信息
PURCHASE_ORDER_DETAILS_ID
PURCHASE_ORDER_ID
ITEM_ID
ITEM_AMOUNT
您能否给我发送存储过程，该存储过程允许如何将多个记录插入到

Hi,
I would need your help. I have a project that I need to insert multiple records into my table. Here is more detail.
I design a purchase order table and purchaseorderdetails
purchaseorder
PURCHASE_ORDER_ID
PO_DATE
CLIENT_ID
purchaseorderdetails
PURCHASE_ORDER_DETAILS_ID
PURCHASE_ORDER_ID
ITEM_ID
ITEM_AMOUNT
Could you please send me the stored procedure that allows how to have multiple records insert into

推荐答案

hi，

这可能对您有用

this may be useful for u

DECLARE @ID int

BEGIN TRANSACTION 
INSERT INTO tbl_user_login VALUES (@UserID, @Pass, @Enabled, @Permission, @Rank)

SET @ID = SCOPE_IDENTITY()    
IF @@ERROR <> 0
BEGIN      
    ROLLBACK     
    RETURN 
END   

INSERT INTO tbl_user_profile VALUES (@ID, @FName, @LName, @Phone, @Email1, @Email2) 

IF @@ERROR <> 0 
BEGIN     
    ROLLBACK     
    RETURN 
END  

COMMIT

从客户端执行SQL语句时，请将其包装在

When executing the SQL statement from the client side, wrap them inside a MySqlTransaction[^]

这篇关于使用Mysql事务插入多个记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！