Using OUTPUT-like clause after INSERT INTO in MySQL

Question

I have a table which has id, name ,surname columns. When I add a new line to table, id increases by 1 since its AI and PK. Now how I get back latest id variable with OUTPUT command?

"INSERT INTO table (name, surname) VALUES ('mike', 'hensen') OUTPUT ?????? how to continue ????"

edit LAST_INSERT_ID() is not a very good method since in a big webpage there could be a lot adding per second.

can you read 4th comment on your question and answer cause this is a big issue. — user3301042
– user3301042, Commented Jul 18, 2015 at 16:22

Gordon Linoff · Accepted Answer · 2015-07-18 16:30:58Z

3

I'm pretty sure that LAST_INSERT_ID() is exactly what you want. It returns the last id inserted on a per connection basis, not the last one inserted (documented here). Presumably, different web users would have different connections, so using the function does what you want.

If you want the last id that was inserted over all connections, but not necessarily from your most recent insert, then you can look at the auto_increment value in the metadata.

answered Jul 18, 2015 at 16:30

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3301042 Over a year ago

(SET @web_id = LAST_INSERT_ID()); how i am gonna echo out the web_id value in php?

Gordon Linoff Over a year ago

@user3301042 . . . You do it with a query following the insert: select last_insert_id().

Collectives™ on Stack Overflow

Using OUTPUT-like clause after INSERT INTO in MySQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related