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 vote197 views1 answer
Initcap in mysql
SQL
3 votes204 views1 answer
Define REGEXP?
SQL
0 vote212 views1 answer
T-sql email validation
SQL
0 vote225 views1 answer
Add week ending date sql server
SQL
0 vote195 views1 answer
How to check the port of mysql installation in mac
SQL
5 votes196 views1 answer
Purge undo tablespace usage
SQL
1 vote339 views1 answer
Postgres upgrade to superuser
SQL
3 votes211 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote184 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote192 views1 answer
Get time component of datetime sql
SQL