Raises an error and terminates the query
Returns the highest value in a column
Adds an error message to the database log
Resets the error counter
USER()
CURRENT_USER()
LOGIN_NAME()
SESSION_USER()
PATTERN BY
MATCHING
LIKE
PATTERN MATCH
ORDER BY DESC
SORT DESC
DESCENDING
REVERSE ORDER
Specifies the range of rows to include in the window function from the start to the current row
Specifies the range of rows to include in the window function from the current row to the end
Excludes the current row from the window function
Specifies the range of rows to include in the window function from the start to the end
Displays warnings generated during the execution of the last statement
Shows all warnings in the database
Lists all columns with warning messages
Clears all warning messages
SQR()
SQRT()
ROOT()
POWER()
ADD COLUMN
INSERT COLUMN
CREATE COLUMN
ALTER COLUMN
Loads data into a table from an external file
Deletes data from a table
Loads data into a temporary table
Inserts a new record into a table
Converts a string to uppercase
Performs a case-sensitive comparison
Adds two binary numbers
Converts a string to lowercase