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 vote115 views3 answers
Get free card roblox
SQL
0 vote142 views1 answer
Pl/pgsql declare variable
SQL
0 vote142 views1 answer
Sql remove decimal places
SQL
0 vote133 views1 answer
Oracle query to find schema you are working on
SQL
0 vote116 views1 answer
Create new table pl sql
SQL
0 vote139 views1 answer
Sql max of two values
SQL
6 votes118 views4 answers
Delete table sqlite
SQL
0 vote126 views1 answer
Vbscript connect mssql
SQL
1 vote118 views1 answer
Mysql drop key
SQL
0 vote128 views1 answer
Sql shell psql cannot enter password
SQL