Conversion

VERSION

MySQL

Mengembalikan string yang menunjukkan versi MySQL server.

Tipe hasil: VARCHAR

Syntax

SQL

VERSION()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT VERSION() AS mysql_version;

Menampilkan versi MySQL.

Hasil

mysql_version: 8.0.35

SQL

1 SELECT CASE 
2   WHEN VERSION() >= '8.0' THEN 'Window functions available'
3   ELSE 'Upgrade recommended'
4 END AS feature_status;

Cek apakah fitur tersedia.

Hasil

feature_status: Window functions available

SQL

1 SELECT VERSION() AS version,
2        DATABASE() AS db,
3        USER() AS user;

Info lengkap sistem.

Hasil

(version, database, user info)

1	SELECT CASE
2	WHEN VERSION() >= '8.0' THEN 'Window functions available'
3	ELSE 'Upgrade recommended'
4	END AS feature_status;