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 vote236 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote225 views1 answer
Get null value in sql
SQL
0 vote185 views1 answer
Mysql add to value
SQL
0 vote230 views1 answer
Combine 2 columns search query mysql
SQL
0 vote206 views1 answer
Disable database droping sql
SQL
0 vote206 views2 answers
Collation in sql
SQL
0 vote194 views1 answer
What is between keyword used for
SQL
0 vote231 views1 answer
Sql convert unix time to date
SQL
0 vote235 views1 answer
Create a plsql object
SQL
0 vote187 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL