Conversion

DATABASE

MySQL

Mengembalikan nama database yang sedang aktif/dipilih saat ini.

Tipe hasil: VARCHAR

Syntax

SQL

DATABASE()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT DATABASE() AS current_db;

Menampilkan database yang sedang aktif.

Hasil

current_db: my_application

SQL

1 SELECT CASE 
2   WHEN DATABASE() = 'production' THEN 'CAREFUL!'
3   ELSE 'Safe to test'
4 END AS environment;

Cek environment berdasarkan database.

Hasil

environment: Safe to test

SQL

1 INSERT INTO audit_log (db_name, action, created_at)
2 VALUES (DATABASE(), 'user_login', NOW());

Log dengan informasi database.

Hasil

(inserted with database name)

1	SELECT CASE
2	WHEN DATABASE() = 'production' THEN 'CAREFUL!'
3	ELSE 'Safe to test'
4	END AS environment;

1	INSERT INTO audit_log (db_name, action, created_at)
2	VALUES (DATABASE(), 'user_login', NOW());