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

-1 vote115 views1 answer
Partial search in sql
SQL
0 vote116 views1 answer
Alasql delete column
SQL
0 vote128 views2 answers
What is the default password for sql server sa
SQL
1 vote133 views2 answers
This month mysql where
SQL
3 votes102 views1 answer
Sql timestamp to date
SQL
0 vote193 views1 answer
Sql database size
SQL
8 votes126 views1 answer
Oracle add datafile to tablespace
SQL
19 votes119 views6 answers
What is mySQL
SQL
2 votes112 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
2 votes113 views1 answer
Get first n letter of department name in sql
SQL