Conversion

LAST_INSERT_ID

MySQL

Mengembalikan nilai AUTO_INCREMENT yang terakhir di-generate untuk kolom dalam koneksi saat ini.

Tipe hasil: BIGINT UNSIGNED

Syntax

SQL

LAST_INSERT_ID([expr])

exprBIGINTopsional

Optional: set nilai yang akan dikembalikan

SQL

1 INSERT INTO users (name) VALUES ('John');
2 SELECT LAST_INSERT_ID() AS new_user_id;

Mendapatkan ID user yang baru dibuat.

Hasil

new_user_id: 42

SQL

1 INSERT INTO orders (customer_id, total) VALUES (1, 100);
2 INSERT INTO order_items (order_id, product_id, qty)
3 VALUES (LAST_INSERT_ID(), 101, 2);

Insert ke tabel terkait dengan foreign key.

Hasil

(linked records inserted)

SQL

1 SELECT LAST_INSERT_ID(1000) AS set_id;
2 -- Subsequent calls return 1000
3 SELECT LAST_INSERT_ID() AS current_id;

Set nilai custom untuk session.

Hasil

set_id: 1000, current_id: 1000

1	INSERT INTO users (name) VALUES ('John');
2	SELECT LAST_INSERT_ID() AS new_user_id;

1	INSERT INTO orders (customer_id, total) VALUES (1, 100);
2	INSERT INTO order_items (order_id, product_id, qty)
3	VALUES (LAST_INSERT_ID(), 101, 2);

1	SELECT LAST_INSERT_ID(1000) AS set_id;
2	-- Subsequent calls return 1000
3	SELECT LAST_INSERT_ID() AS current_id;