Mysql get last insert id

Mysql id of inserted row

-- For mysql
INSERT INTO table_name (col1, col2,...) VALUES ('val1', 'val2'...);
SELECT LAST_INSERT_ID();

Source: stackoverflow.com

Mysql get last insert id

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

Mysql set last_insert_id

SET @last_id = LAST_INSERT_ID();

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;

Find last id

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

$last_id = $newOrder->id;

Similar codes

4 votes343 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote326 views1 answer
Alter table column size oracle
SQL
3 votes395 views3 answers
Update con select postgresql
SQL
5 votes330 views1 answer
Update sql user password
SQL
1 vote327 views1 answer
Median mysql
SQL
0 vote342 views1 answer
Mysql c commands
SQL
1 vote337 views2 answers
Sql example query
SQL
0 vote341 views1 answer
Create table as select sql server error
SQL
1 vote349 views1 answer
Cannot drop database because it is currently in use
SQL
1 vote376 views2 answers
Full join
SQL