Question

How can the value of recently generated sequence number be obtained?

(a) LAST_INSERT_ID()

(b) LATEST_INSERT_ID()

(c) INITIAL_INSERT_ID()

(d) INSERT_ID()

I got this question in class test.

My question is taken from Internal Security: Preventing Unauthorized Filesystem Access topic in chapter Access Control and Security of MySQL

Answer 1

Correct choice is (a) LAST_INSERT_ID()

For explanation I would say: The value of most recently generated sequence number can be obtained by calling the LAST_INSERT_ID() function. This enables to reference the AUTO_INCREMENT value in the subsequent statement.