MySQL의 다중 행 INSERT 문에서 LAST_INSERT_ID()는 어떻게 작동합니까?

Returning the Last Insert ID in Multi-Row INSERT Statements Using LAST_INSERT_ID() in MySQL

When executing multiple record insertions in MySQL, understanding the behavior of the LAST_INSERT_ID() function becomes crucial. Unlike single-row insertions where it provides the ID of the inserted row, LAST_INSERT_ID() behaves differently with multi-row INSERT statements.

For example, consider the following query:

INSERT INTO people (name, age)
VALUES ('William', 25), ('Bart', 15), ('Mary', 12);

After executing this statement, one might expect the LAST_INSERT_ID() function to return the ID of the last inserted row (3). However, the behavior of LAST_INSERT_ID() diverges from this expectation.

LAST_INSERT_ID() Returns the First Insert ID

In the context of multiple record INSERT statements, LAST_INSERT_ID() returns the ID generated for the first inserted row only. This behavior is explicitly documented in MySQL's documentation:

Important
If you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only.

This design decision ensures that the same INSERT statement can be easily reproduced on another server without any issues. By using the ID of the first inserted row, reproducing the intended behavior becomes straightforward.

Implications for Code Design

Understanding this behavior is crucial when designing code that relies on the LAST_INSERT_ID() function for multi-row insertions. Developers should avoid relying on LAST_INSERT_ID() to determine the specific IDs of inserted rows in such scenarios. Alternative approaches for tracking or accessing row IDs in multi-row insertions should be considered.

위 내용은 MySQL의 다중 행 INSERT 문에서 LAST_INSERT_ID()는 어떻게 작동합니까?의 상세 내용입니다. 자세한 내용은 PHP 중국어 웹사이트의 기타 관련 기사를 참조하세요!