INSERT and SELECT in a single query string MySql C#

Question

I need to insert a row and use that "last id" immediately so I need to execute a query like this

INSERT INTO table_name (col1, col2,...) VALUES ('val1', 'val2'...);
SELECT LAST_INSERT_ID();

I know that to INSERT I must call cmd.ExecuteNonQuery() and to SELECT I call cmd.ExecuteReader()

But how to do both in a single query?

You can use something like scope identity....https://stackoverflow.com/questions/560783/the-equivalent-of-sqlserver-function-scope-identity-in-mysql — Hari Govind, Oct 16 '17 at 07:31
This case can only be solved by putting all commands into stored procedure then use `ExecuteReader` and get `SELECT` output result from it. — Tetsuya Yamamoto, Oct 16 '17 at 08:41

score 0 · Answer 1 · answered Oct 16 '17 at 09:19

0

Try the following after insert query:

SELECT MAX(id) FROM tablename;

or

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

answered Oct 16 '17 at 09:19

Morgan Kamoga

1 Answers1