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

1 vote386 views1 answer
Sql count value greater than
SQL
6 votes345 views2 answers
Psql load dump
SQL
1 vote377 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote317 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote381 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote429 views1 answer
Stop and start mysql
SQL
1 vote353 views1 answer
SQL query to get all table records count from a database
SQL
0 vote335 views1 answer
Show table details postgresql
SQL
3 votes317 views1 answer
Index using in query plsql
SQL
0 vote382 views1 answer
How to add mysql to path on termin after installation
SQL