返回上一个ID(IDENTITY)在插入行VB.NET MySQL上

发布时间：2020-12-17 00:22:19 所属栏目：大数据来源：网络整理

导读：Dim insert_coupon_query As String = ("INSERT INTO qa_discountcoupons (id,status_code) VALUES (AUTO_INCREMENT_ID,5)") Dim cmd_query As New MySqlCommand(insert_coupon_query,objConn) Dim cmd_result As Integer = CInt(cmd_query.ExecuteScalar())

Dim insert_coupon_query As String = ("INSERT INTO qa_discountcoupons (id,status_code) VALUES (AUTO_INCREMENT_ID,5)")
                Dim cmd_query As New MySqlCommand(insert_coupon_query,objConn)
                Dim cmd_result As Integer = CInt(cmd_query.ExecuteScalar())

我想返回当前插入的AUTO_INCREMENT值,并显示在msgbox中.

您可以使用双查询并使用函数 LAST_INSERT_ID()运行第一个查询后获取上一个当前查询：

Dim insert_coupon_query As String = ("INSERT INTO qa_discountcoupons (status_code) VALUES (5); SELECT LAST_INSERT_ID()")
                Dim cmd_query As New MySqlCommand(insert_coupon_query,objConn)
                Dim cmd_result As Integer = CInt(cmd_query.ExecuteScalar())

                MsgBox(cmd_result)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!