What is @lastID in this entry: SET @lastID := LAST_INSERT

K

khodos_dmitry2018-03-01 12:05:22

MySQL

khodos_dmitry, 2018-03-01 12:05:22

What is @lastID in this entry: SET @lastID := LAST_INSERT_ID()?

Haven't come across this yet.
And another question: does LAST_INSERT_ID() take the value of the last updated row? Not inserted, but updated.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

O

OKyJIucT, 2018-03-01
@khodos_dmitry

This is a variable that can be used in further queries. No, it only takes the value of the last inserted row.