Mysql get last inserted id

Mysql get last insert id

SELECT MAX(id) AS last_id FROM users
-- last_id --
-- 33 --

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

Find last id

//laravel controller
$newOrder = new Order();
...
...
$newOrder->save();

$last_id = $newOrder->id;

Return last inserted id mysql opencart

//You need to use this in OpenCart for getting last insert id:
$this->db->getLastId()

Source: stackoverflow.com

Similar codes

0 vote161 views1 answer
Sql server alter table column nullable
SQL
2 votes157 views1 answer
Sqlplus clear screen
SQL
0 vote177 views1 answer
Mysql, how to query the table comments?
SQL
12 votes178 views4 answers
How to check mysql version ubuntu
SQL
18 votes163 views6 answers
Creating table in MySQL
SQL
6 votes203 views2 answers
Oracle compile trigger
SQL
4 votes163 views2 answers
Tsql utf to local time
SQL
0 vote152 views1 answer
How to get initials in sql
SQL
4 votes209 views1 answer
Rename stored procedure in sql server
SQL
1 vote193 views1 answer
Convert to hexadecimal sql
SQL