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 vote252 views1 answer
Select only one row sql
SQL
5 votes313 views2 answers
How to ascending order in sql
SQL
1 vote264 views1 answer
Oracle finding duplicate records
SQL
0 vote270 views1 answer
Install squirrel sql ubuntu
SQL
2 votes271 views1 answer
How to make multiple keys as primary in bdms
SQL
5 votes245 views3 answers
Truncate function in sql oracle
SQL
0 vote251 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote264 views1 answer
Postgres select as csv
SQL
0 vote265 views1 answer
Data structures in sql
SQL
4 votes252 views1 answer
To date oracle with time
SQL