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

0 vote380 views1 answer
Mysql extract day from date leading zero
SQL
10 votes371 views3 answers
Join multiple tables sql
SQL
1 vote342 views1 answer
Oracle apex prevent initial load
SQL
0 vote365 views1 answer
Display all node label neo4j
SQL
5 votes350 views1 answer
Sql use database
SQL
0 vote399 views2 answers
Mysql show foreign keys
SQL
2 votes356 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote362 views3 answers
Postgresql allow remote connections
SQL
44 votes407 views6 answers
Rename command in sql
SQL
19 votes371 views3 answers
How to change column type psql
SQL