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 vote349 views1 answer
How to group by month using sql server
SQL
0 vote334 views1 answer
Bigquery declare
SQL
1 vote345 views1 answer
Select if then postgresql
SQL
3 votes354 views3 answers
Sql last week
SQL
0 vote333 views1 answer
Add alternate add column sql
SQL
0 vote353 views1 answer
Create function in microsoft sql server
SQL
0 vote354 views1 answer
Allow external access to mysql
SQL
0 vote363 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote313 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
16 votes337 views4 answers
Mysql import from sql file
SQL