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 vote136 views1 answer
Find invalid datetime field
SQL
-1 vote144 views3 answers
Psql get last rows
SQL
8 votes138 views3 answers
Connect python to mysql
SQL
8 votes134 views1 answer
Ltrim sql
SQL
0 vote144 views1 answer
If column value is null then in mysql
SQL
1 vote127 views1 answer
Import local sql into remote mysql
SQL
0 vote187 views1 answer
Contraint default SQL
SQL
0 vote137 views1 answer
T-sql conditional order by multiple columns
SQL
1 vote132 views1 answer
How to see logical reads in sql server
SQL
0 vote145 views2 answers
Py sqlite if entry exists
SQL