Fungsi SQL MySQL

Returns the connection ID (thread ID) for the current connection.

Converts a number from one base to another. Supports bases from 2 to 36.

Mengkonversi nilai ke tipe data atau charset tertentu. Alternatif untuk CAST dengan sintaks berbeda.

Returns the name of the currently active (selected) database.

Formats a number with thousands separators and a specified number of decimal places. Useful for displaying numbers in a human-readable format.

Converts a Unix timestamp to a DATETIME value or a formatted string. The inverse of UNIX_TIMESTAMP().

Converts an IPv4 or IPv6 address string to binary format. Supports both IP address formats.

Converts a binary IP address to string format. This is the reverse of INET6_ATON().

Converts an IPv4 address string to an unsigned integer. Useful for efficient storage and range-based IP queries.

Converts an unsigned integer to an IPv4 address string. The inverse of INET_ATON().

Returns the last AUTO_INCREMENT value generated for a column in the current connection.

Converts a decimal number to its octal string representation. Shorthand for CONV(num, 10, 8).

Converts a string to a DATE, DATETIME, or TIME value based on the provided format string. The inverse of DATE_FORMAT.

Formats a TIME value into a string according to the specified format. Similar to DATE_FORMAT but designed specifically for time values.

Returns the Unix timestamp (seconds since 1970-01-01 00:00:00 UTC). When called with no argument, returns the current Unix timestamp.

Returns the username and hostname of the current MySQL connection.

Generates a version 1 Universal Unique Identifier (UUID). The returned value follows the format: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.

Generates a unique 64-bit unsigned integer. Faster and more compact than UUID().

Converts a UUID string to BINARY(16) format for more efficient storage.

Returns a string indicating the MySQL server version.