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()
Removes a specific column from a table
Extracts a substring from a string
Extracts a part (year, month, day, etc.) from a date or time
Extracts a numeric value from a column
