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 vote134 views1 answer
Authentication in sql server
SQL
0 vote159 views2 answers
How to type a blank discord messgae
SQL
9 votes147 views3 answers
Mysql run sql file
SQL
2 votes124 views2 answers
Get all columns from table sql
SQL
0 vote158 views1 answer
Sql convert unix time to date
SQL
8 votes149 views1 answer
Check mysql version phpmyadmin
SQL
3 votes131 views3 answers
Print in pl sql
SQL
1 vote182 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote164 views1 answer
Split first name and last name in sql
SQL
-1 vote133 views1 answer
Search all database tables for a value sqlserver
SQL