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 vote360 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote358 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote360 views1 answer
Sql replace id with name from another table
SQL
0 vote407 views1 answer
Tsql cte in a transaction
SQL
0 vote348 views1 answer
Pl/ sql change currency
SQL
1 vote349 views1 answer
Add current timestamp in mysql
SQL
0 vote411 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
1 vote336 views6 answers
In sql
SQL
42 votes429 views6 answers
Sql query duplicate rows
SQL
0 vote368 views1 answer
Transaction database with php
SQL