Answers for "get the last inserted row in mysql"

mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

Posted by: Guest on March-04-2020

mysql get last inserted id

-- To get the last inserted auto-increment row ID: --
SELECT LAST_INSERT_ID( optional_expression )

-- If you have just inserted it using a command in C# use: --
int lastId = (Int32)yourCommand.LastInsertedId;

Posted by: Guest on May-15-2020

Code answers related to "get the last inserted row in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get the last inserted row in mysql"

Code answers related to "get the last inserted row in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get the last inserted row in mysql"

Code answers related to "get the last inserted row in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us