Mysql get last id

Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

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;

Mysql get last id

SELECT MAX(id) FROM tablename;

Source: stackoverflow.com

Similar codes

5 votes192 views1 answer
Sql add column after another
SQL
0 vote199 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote203 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote206 views1 answer
Mysql month name extract
SQL
3 votes201 views1 answer
Sql print all names that start with a given letter
SQL
5 votes168 views1 answer
Alter table default value mysql
SQL
0 vote192 views1 answer
Table or view does not exist
SQL
0 vote203 views1 answer
Sql server list table sizes
SQL
0 vote191 views1 answer
Sql convert datetime to year
SQL
0 vote259 views1 answer
Mssql describe stored procedure sqlcmd
SQL