TOTAL ROWS
COUNT ROWS
NUMROWS
SELECT COUNT(*)
Returns the position of a substring in a string
Retrieves the minimum value in a column
Counts the number of rows in a result set
Concatenates rows into a single string based on a specified condition
Removes all records from a table
Trims leading and trailing spaces from a string
Deletes a specific column from a table
Rounds a numeric value to the nearest integer
USER()
CURRENT_USER()
LOGIN_NAME()
SESSION_USER()
SQR()
SQRT()
ROOT()
POWER()
Converts a string to uppercase
Performs a case-sensitive comparison
Adds two binary numbers
Converts a string to lowercase
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
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