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

18 votes161 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote140 views1 answer
Deleted table in sql trigger
SQL
0 vote170 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
4 votes230 views1 answer
Postgresql list sequences
SQL
0 vote167 views1 answer
Not between mysql
SQL
0 vote205 views1 answer
Display all node label neo4j
SQL
0 vote210 views1 answer
Select 1 from orders
SQL
17 votes185 views5 answers
Order by sql
SQL
0 vote171 views1 answer
Move table to a different schema
SQL
0 vote186 views2 answers
Enter into postgresql database,create user and grant Access
SQL