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 vote208 views1 answer
Mysql update privileges
SQL
6 votes222 views1 answer
Postgres get size of database
SQL
0 vote209 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote212 views1 answer
Oracle create package specification
SQL
5 votes221 views2 answers
Oracle apex debug mode
SQL
0 vote243 views1 answer
Stored procedure function relation
SQL
0 vote240 views1 answer
Mysql get hour from datetime
SQL
26 votes165 views10 answers
Insert in to table sql
SQL
0 vote225 views1 answer
Mysql sum with group by
SQL
0 vote213 views1 answer
Select last N rows mysql
SQL