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 vote241 views1 answer
Creating sqeuence in oracle database
SQL
3 votes262 views2 answers
Brew restart mysql
SQL
0 vote206 views1 answer
Update one column from another column in same table
SQL
0 vote201 views1 answer
How to install sql in anaconda
SQL
0 vote224 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote204 views2 answers
Oracle create chain rule
SQL
9 votes203 views3 answers
Mysql show table column full description
SQL
0 vote283 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote217 views1 answer
Sql date time query find
SQL
4 votes196 views1 answer
Select nls_date_format
SQL