ALTER COLUMN
MODIFY COLUMN
CHANGE COLUMN
CONVERT COLUMN
Returns the first non-null expression among its arguments
Concatenates rows into a single string based on a specified condition
Calculates the average value of numeric column values
Retrieves the maximum value among the specified expressions
A key used for sorting the table
A unique identifier for a record in a table
A key used for encryption
A column or a set of columns in a table that refers to the primary key of another table
POSITION()
LOCATE()
FIND()
SEARCH()
Converts a date to a string with a specified format
Adds a specified number of days to a date
Retrieves the current date and time
Returns the difference between two dates
DROP CONSTRAINT
REMOVE CONSTRAINT
ALTER TABLE
DELETE CONSTRAINT
Deletes all records from a table
Retrieves data from a table
Performs a specific action when an event occurs
Adds a new column to a table
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
EXCLUDE
IGNORE
WHERE NOT
NOT
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
SELF JOIN
INNER JOIN
CROSS JOIN
LEFT JOIN
Displays the structure of a table
Shows the relationships between tables
Lists all columns in a table
Retrieves the values in a specific column
REVOKE ALL
DENY ALL PRIVILEGES
REVOKE PRIVILEGES
REMOVE ALL PRIVILEGES
Checks if a table exists in the database
Tests for the existence of rows in a subquery
Checks if a column exists in a table
Tests for the existence of a database
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()
Returns the row number of a result set
Counts the total number of rows in a table
Retrieves the last row in a result set
Assigns a unique identifier to each row in a table
PATTERN BY
MATCHING
LIKE
PATTERN MATCH
Flushes the contents of a table
Refreshes the privileges held by the server
Deletes all privileges from a user
Flushes the query cache
Returns the average value of the arguments
Returns the first non-null argument
Concatenates the arguments into a single string
Adds up all the arguments
