Return Last ID (IDENTITY) On Insert row VB.NET MySQL

by

You can use an double Query and use the function LAST_INSERT_ID() After run your first query to get the last current query:

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)

More Related Contents:

  1. Store image to database blob; retrieve from db into Picturebox
  2. Query from two tables in report
  3. Is it safe to store usernames and passwords in the database?
  4. Equivalent of MSSQL IDENTITY Column in MySQL
  5. what will be the sql query code of this “Healthcare” database?
  6. Rank function in MySQL
  7. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  8. Find nearest latitude/longitude with an SQL query
  9. Include headers when using SELECT INTO OUTFILE?
  10. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  11. MySQL timezone change?
  12. ON DUPLICATE KEY + AUTO INCREMENT issue mysql
  13. What is this operator in MySQL?
  14. Cronjob or MySQL event?
  15. How to insert BLOB and CLOB files in MySQL?
  16. 60 million entries, select entries from a certain month. How to optimize database?
  17. How to start spring-boot app without depending on Database?
  18. Is it possible to GROUP BY multiple columns using MySQL?
  19. MySQL compare DATE string with string from DATETIME field
  20. MySQL monthly Sale of last 12 months including months with no Sale
  21. How to fuzzy match email or telephone by Elasticsearch?
  22. “SELECT COUNT(*)” is slow, even with where clause
  23. MySQL – select data from database between two dates
  24. Calculating a Moving Average MySQL?
  25. Check if a column exists in a table with SQL
  26. Can MySQL use multiple indexes for a single query?
  27. Does replace into have a where clause?
  28. MySql. How to use Self Join
  29. MySQL OPTIMIZE all tables?
  30. mysql double-quoted table names

Leave a Comment