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

6 votes148 views5 answers
Sql add months to date
SQL
0 vote159 views1 answer
Sql log file inof
SQL
0 vote156 views1 answer
Select multiple row from primary key sql
SQL
0 vote152 views1 answer
Sql values that contains certain multiple ids
SQL
4 votes197 views1 answer
Oracle change nls_date_format permanently
SQL
1 vote154 views1 answer
Sql select whole row max column
SQL
0 vote189 views1 answer
Drop a view in sqlite
SQL
2 votes153 views1 answer
Drop all foreign key constraints mysql
SQL
3 votes168 views1 answer
Force using index oracle
SQL
6 votes142 views1 answer
What is where clause in sql
SQL