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 vote175 views2 answers
Execute stored procedure without db set
SQL
50 votes183 views6 answers
Sql duplicate rows
SQL
1 vote180 views2 answers
Sql queries practice
SQL
0 vote183 views1 answer
Sql server sleep
SQL
0 vote170 views1 answer
Mysql error codeigniter
SQL
0 vote182 views1 answer
How to create a new shema using query languaage
SQL
0 vote213 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote182 views1 answer
How to select a row in sql
SQL
0 vote162 views1 answer
Sql row number in result set
SQL
1 vote159 views2 answers
T-sql random number for each row
SQL