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

0 vote290 views1 answer
Oracle db get table sizes
SQL
0 vote273 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote286 views1 answer
Month mysql
SQL
1 vote298 views1 answer
Postgresql escape single quote
SQL
0 vote321 views1 answer
Mysql record group by created date count
SQL
5 votes319 views4 answers
Mysql update column with value from another table
SQL
6 votes296 views5 answers
Mysql get last insert id
SQL
0 vote292 views1 answer
Do postgresql
SQL
1 vote305 views2 answers
Begin transaction in sql
SQL
1 vote309 views1 answer
How to lock table in mysql
SQL