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

3 votes374 views1 answer
Sql select second max
SQL
0 vote308 views1 answer
Mysql value ends with
SQL
0 vote326 views1 answer
How to check rollback status in oracle
SQL
0 vote309 views2 answers
Unique key
SQL
1 vote292 views1 answer
Oracle turn off constraint
SQL
0 vote281 views1 answer
Get cpu details sql
SQL
10 votes254 views2 answers
Sql where clause multiple values
SQL
0 vote302 views1 answer
Consulta alias con inner join
SQL
10 votes315 views2 answers
Doublon sql
SQL
0 vote274 views1 answer
Mysql drop multiple tables at once
SQL