Conversion

CONNECTION_ID

MySQL

Mengembalikan ID koneksi (thread ID) untuk koneksi saat ini.

Tipe hasil: BIGINT UNSIGNED

Syntax

SQL

CONNECTION_ID()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT CONNECTION_ID() AS my_conn_id;

Mendapatkan ID koneksi saat ini.

Hasil

my_conn_id: 1234567

SQL

1 INSERT INTO debug_log (connection_id, query, logged_at)
2 VALUES (CONNECTION_ID(), 'SELECT * FROM users', NOW());

Logging dengan connection ID.

Hasil

(inserted with connection ID)

SQL

1 SELECT * FROM information_schema.PROCESSLIST
2 WHERE ID = CONNECTION_ID();

Melihat info proses sendiri.

Hasil

(current connection info)

1	INSERT INTO debug_log (connection_id, query, logged_at)
2	VALUES (CONNECTION_ID(), 'SELECT * FROM users', NOW());

1	SELECT * FROM information_schema.PROCESSLIST
2	WHERE ID = CONNECTION_ID();