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

13 votes218 views2 answers
Oracle inner join
SQL
7 votes226 views1 answer
Sql limit decimal places
SQL
1 vote211 views1 answer
Sql select where id not exists in another table
SQL
14 votes232 views6 answers
Auto_increment mysql
SQL
3 votes248 views4 answers
Truncate syntax in sql
SQL
0 vote228 views1 answer
Oracle running queries
SQL
16 votes277 views2 answers
Sql vs nosql
SQL
2 votes216 views1 answer
How to create sql database
SQL
0 vote211 views1 answer
Replace multiple string in query sql
SQL
0 vote250 views1 answer
Finding leap year in sql
SQL