Fungsion SQL

Variable/Function		    Output

@@hostname	      	        Current Hostname
@@tmpdir.  	      	        Tept Directory
@@datadir		            Data Directory
@@version		            Version of DB
@@VERSION_COMPILE_OS        Version Operating System
@@VERSION_COMPILE_MACHINE   Server Os Type
@@basedir		            Base Directory
user()		                Current User
database()		            Current Database
SCHEMA()	                Current Database
version()		            Version
@@GLOBAL.VERSION            Version
@@VERSION_COMMENT           Version
schema()		            current Database
UUID()		                System UUID key
current_user()		        Current User
current_user		        Current User
system_user()		        Current Sustem user
session_user()		        Session user
@@GLOBAL.have_symlink	    Check if Symlink Enabled or Disabled
@@HAVE_SYMLINK              Check if Symlink Enabled or Disabled
@@GLOBAL.have_ssl		    Check if it have ssl or not
@@HAVE_OPENSSL              Check if it have ssl or not
@@CHARACTER_SETS_DIR        Get Server Folders
@@LOG_ERROR                 Get Server Folders
@@LANGUAGE                  Get Server Folders
@@PID_FILE                  Get Server Folders
@@PLUGIN_DIR                Get Server Folders
@@SOCKET                    Get Server Folders
@@BASEDIR                   Get Server Folders
@@DATADIR                   Get Server Folders
@@SLAVE_LOAD_TMPDIR         Get Server Folders
@@PORT                      Port
@@WAIT_TIMEOUT              Time Out Connection
@@MYISAM_RECOVER_OPTIONS    Recover Options



[+] SQL Aggregate Functions [+]

SQL aggregate functions return a single value, calculated from values in a column.
Function 	    Description
AVG() 	        Returns the average value
COUNT() 	    Returns the number of rows
FIRST() 	    Returns the first value
LAST() 	        Returns the last value
MAX() 	        Returns the largest value
MIN() 	        Returns the smallest value
ROUND() 	    Rounds a numeric field to the number of decimals specified
SUM() 	        Returns the sum

[+] SQL String Functions [+]
Function 	           Description
CHARINDEX 	           Searches an expression in a string expression and returns its starting position if found
CONCAT()
LEFT()
LEN() / LENGTH() 	   Returns the length of the value in a text field
LOWER() / LCASE() 	   Converts character data to lower case
LTRIM()
SUBSTRING() / MID()    Extract characters from a text field
PATINDEX()
REPLACE()
RIGHT()
RTRIM()
UPPER() / UCASE() 	   Converts character data to upper case

[+] MySQL Date Functions [+]

The following table lists the most important built-in date functions in MySQL:
Function 	    Description
NOW() 	        Returns the current date and time
CURDATE() 	    Returns the current date
CURTIME() 	    Returns the current time
DATE() 	        Extracts the date part of a date or date/time expression
EXTRACT() 	    Returns a single part of a date/time
DATE_ADD() 	    Adds a specified time interval to a date
DATE_SUB() 	    Subtracts a specified time interval from a date
DATEDIFF() 	    Returns the number of days between two dates
DATE_FORMAT() 	Displays date/time data in different formats

[+] SQL Null Functions [+]
ISNULL()
NVL()
IFNULL()
COALESCE()