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

10 votes117 views4 answers
Else if mysql
SQL
0 vote99 views3 answers
Joins and views sql
SQL
0 vote135 views1 answer
Sql date time query find
SQL
6 votes116 views1 answer
Identify primary key in oracle table
SQL
0 vote117 views2 answers
Oracle select
SQL
0 vote113 views1 answer
Oracle sql add column auto generated value
SQL
0 vote103 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote108 views1 answer
Update and keep original value sql
SQL
1 vote130 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote108 views1 answer
Sql server set complex constraints
SQL