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

11 votes246 views1 answer
Mysql order by two columns priority
SQL
0 vote232 views1 answer
Restore backupfile discourse
SQL
7 votes241 views2 answers
Execute mysql file
SQL
0 vote236 views1 answer
Except in sql alchemy
SQL
0 vote247 views1 answer
Adding generated time in row mysql workbench
SQL
7 votes233 views2 answers
Add column table pl sql
SQL
0 vote230 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote260 views1 answer
Cahnge column name apex oracle
SQL
0 vote242 views1 answer
Sql case sttement with set
SQL
1 vote235 views1 answer
Postgres concat_ws
SQL