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 vote195 views1 answer
SQL Where-Klausel
SQL
1 vote128 views1 answer
Oracle character set
SQL
0 vote167 views1 answer
Mysql select all table that have field names
SQL
0 vote154 views1 answer
Dnsmasq.conf location macos
SQL
1 vote167 views2 answers
Mysql filter by date mount
SQL
5 votes234 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
2 votes165 views2 answers
Change varchar length mysql
SQL
1 vote220 views1 answer
Check current sequence value postgres
SQL
0 vote168 views1 answer
How to start my sql server on mac
SQL
20 votes190 views6 answers
Creating a table in sql
SQL