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 vote127 views1 answer
Datagrip execute procedure
SQL
0 vote123 views2 answers
Sql server select where date
SQL
0 vote130 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote129 views1 answer
Convert polygon to text in mysql
SQL
2 votes134 views1 answer
Sql missing records from another table
SQL
0 vote157 views1 answer
Compare strings lexicographically in sql
SQL
0 vote136 views1 answer
Sql log file inof
SQL
0 vote128 views1 answer
Enable sql server full text indexing
SQL
0 vote117 views1 answer
Sql server select furst day of current year
SQL
0 vote122 views1 answer
How to set sql_mode for a query in CI model
SQL