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 vote177 views1 answer
Select top values sql
SQL
0 vote176 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
10 votes163 views2 answers
Rtrim sql
SQL
0 vote194 views1 answer
Delete from table where length sql
SQL
4 votes159 views3 answers
Sql drop primary key
SQL
16 votes158 views4 answers
Mysql import from sql file
SQL
1 vote175 views1 answer
Key validation sql
SQL
6 votes160 views4 answers
Mysql group by date
SQL
0 vote278 views1 answer
Oracle convert int to date
SQL
1 vote170 views1 answer
How to delay stored procedure execution in sql server
SQL