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 vote193 views1 answer
Sqlite insert or update
SQL
0 vote180 views1 answer
Storing RGBA in mysql db
SQL
21 votes178 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
9 votes194 views3 answers
Where clause sql
SQL
3 votes277 views1 answer
How to get yesterday date in sql
SQL
0 vote181 views2 answers
Database owner can't create new tables postgres
SQL
0 vote181 views1 answer
Show database not empty tables postgres
SQL
11 votes186 views1 answer
Ddl materialized view
SQL
0 vote183 views1 answer
Mysql failed to login as root@localhost
SQL
6 votes175 views5 answers
Alter table oracle
SQL