How to get the just-inserted record ID (mysql)?

Question

How to get the just-inserted record ID (mysql)? What i'll add to query:

INSERT INTO `osoby` (`imie`,`nazwisko`)
VALUES ('wartość','wartość2')

? thanks.

This will INSERT the values, you need SELECT to fetch data – swapnesh Jan 15 '13 at 18:25 — swapnesh, Jan 15 '13 at 18:25

score 5 · Answer 1 · answered Jan 15 '13 at 18:26

5

To get the last inserted id use

SELECT LAST_INSERT_ID()

answered Jan 15 '13 at 18:26

Denys Séguret

i just show you this http://stackoverflow.com/questions/3180510/last-insert-id-vs-select-maxid – echo_Me Jan 15 '13 at 19:53

1 Answers1