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

23 votes116 views3 answers
Mysqldump
SQL
0 vote160 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote140 views1 answer
Add colum date in sql
SQL
0 vote143 views2 answers
How to tun mysql on ubunto
SQL
0 vote147 views4 answers
Postgresql between month
SQL
0 vote147 views1 answer
Longtext sql
SQL
8 votes194 views2 answers
Default sql server port
SQL
0 vote162 views1 answer
Mysql remove bad character from all fields
SQL
1 vote144 views1 answer
Sql trigger before delete
SQL
-1 vote105 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL