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 vote204 views2 answers
Find nth highest salary of an employee
SQL
0 vote176 views1 answer
Sql right characters
SQL
0 vote176 views1 answer
Sql server split string and insert into table select
SQL
0 vote209 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
11 votes180 views1 answer
Oracle view ddl
SQL
0 vote253 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote226 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote169 views1 answer
Alter table add foreign key mariadb example
SQL
2 votes312 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote194 views1 answer
Set statiscis on in ssms
SQL