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 vote231 views1 answer
Sql server select value large text
SQL
0 vote239 views1 answer
Group by two columns postgres
SQL
1 vote219 views1 answer
Show table status command in mysql
SQL
0 vote234 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
3 votes255 views2 answers
Sql add year to date
SQL
3 votes221 views1 answer
Force using index plsql
SQL
0 vote247 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote180 views1 answer
Sqlalchemy existing database
SQL
0 vote219 views1 answer
Mysql delete from where like
SQL
0 vote213 views1 answer
Mod function example
SQL