To discard all changes made in a transaction
To refresh the table cache
To delete all records from a table
To optimize and flush the changes to disk for all tables
MODIFY COLUMN
ALTER TYPE
CHANGE COLUMN
ALTER COLUMN
Disables foreign key checks for the current session
Enables foreign key checks for the entire database
Deletes all foreign keys from a table
Modifies the structure of a foreign key
Converts a value to binary
Returns the binary representation of a string
Retrieves the last inserted binary data
Checks if a value is binary
LOCATE()
FIND()
SEARCH()
POSITION()
Removes all records from a table
Trims leading and trailing spaces from a string
Truncates a table structure
Performs mathematical operations on numeric values
GRANT SELECT ON database.* TO user;
GRANT ALL PRIVILEGES ON database.* TO user;
GRANT DATABASE SELECT TO user;
GRANT USER SELECT ON database.*;
Retrieves the previous value in a result set based on a specified order
Returns the next value in a result set based on a specified order
Calculates the average value for each group of rows
Counts the number of rows in a result set
A key used for sorting the table
A unique identifier for a record in a table
A key used for encryption
A column or set of columns that refers to the primary key of another table
ALTER TABLE
Returns the first non-null expression among its arguments
Compares two expressions and returns null if they are equal
Converts a value to uppercase
Concatenates two or more strings
WHERE
GROUP
FILTER
CONDITION
Rounds a numeric value to the nearest integer
Formats a date or numeric value according to a specified format
Converts a string to lowercase
Retrieves the length of a string
DENY ALL PRIVILEGES
REVOKE ALL
REVOKE ALL PRIVILEGES
DELETE PRIVILEGES
A function that increments a numeric value by a specified step
A constraint used for sorting the table
A unique identifier for a record in a table that increments automatically
A command to increment the value of a column
Removes all rows from a table
Deletes a specific record from a table
CONVERT COLUMN
Assigns a unique number to each row in a result set
Counts the total number of rows in a table
Orders the rows in a result set
Retrieves the maximum value in a column
Resets the database engine
Clears the query cache
Reloads the privilege tables
Drops all indexes from a table
CURRENT_USER()
USER_NAME()
SESSION_USER()
SYSTEM_USER()