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

6 votes158 views3 answers
Mysql server is not starting xampp
SQL
0 vote161 views1 answer
Delete record by id sql
SQL
0 vote201 views1 answer
Mysql show schema
SQL
4 votes157 views4 answers
Oracle tablespace tables list
SQL
2 votes165 views1 answer
Mysql change data type of column
SQL
0 vote153 views1 answer
How to fix mysql stop unexpectedly
SQL
1 vote198 views1 answer
Mysql tables max count
SQL
0 vote196 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote180 views1 answer
Mysql show long running queries
SQL
1 vote169 views1 answer
Sql select row with max date
SQL