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 vote300 views1 answer
Procedures sql insert mysql
SQL
7 votes323 views5 answers
Sql remove spaces
SQL
3 votes266 views1 answer
How to get list of synonyms in oracle
SQL
1 vote308 views1 answer
Grab all records from one table to another oracle sql
SQL
6 votes294 views3 answers
Mysql first day of year
SQL
6 votes296 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
10 votes309 views3 answers
Sql check double value
SQL
0 vote316 views1 answer
Get enginge db mysql
SQL
1 vote302 views1 answer
Pv mysql import
SQL
0 vote292 views1 answer
Sql gap missing values
SQL