REVOKE
DENY
REMOVE PRIVILEGES
DELETE PRIVILEGES
To remove all privileges from a user
To reload the grant tables and apply changes made with the GRANT statement
To flush the cache memory
To restart the MySQL server
To find the modulus of two numbers
To perform modulo arithmetic
To concatenate strings
To round a numeric value
CHANGE COLUMN
ALTER COLUMN TYPE
MODIFY COLUMN
UPDATE COLUMN TYPE
To display a list of all tables in the current database
To show the relationships between tables
To display the structure of a table
To show the indexes of a table
To count the total number of rows in a result set
To assign a unique number to each row within a partition of a result set
To retrieve the row with the maximum value in a column
To calculate the average value of a column
Combines the result sets of two or more SELECT statements and includes duplicate rows
Concatenates strings from multiple columns
Groups the result set based on a specific column
Performs a mathematical union operation on numeric values
LENGTH()
CHAR_LENGTH()
STRLEN()
LEN()
Converts a value to lowercase
Returns the first non-null expression among its arguments
Concatenates two or more strings
Performs arithmetic operations on numeric values
A temporary table created for a specific query
A group of SQL statements that can be executed as a single unit
A constraint used to ensure data integrity
A function that calculates the average value of a column
IN
BETWEEN
LIKE
IS NULL
Calculates the average value for each group of rows
Counts the number of rows in each group
Filters groups based on a condition
Retrieves the maximum value in each group
ALTER TABLE
UPDATE
MODIFY TABLE
CHANGE TABLE
Retrieves the current date and time
Converts a string to uppercase
Rounds a numeric value to the nearest integer
Returns the length of a string
A virtual table based on the result of a SELECT query
A physical table with stored data
A temporary table for sorting purposes
A table that contains only primary key columns
DENY PRIVILEGES
To sort the result set in ascending order
To filter rows based on a condition
To include subtotals and grand totals in the result set
To perform a join operation between tables
INSERT INTO
ADD RECORD
CREATE RECORD
Returns the greatest value among the specified expressions
Retrieves the last record from a table
Combines two or more strings
Converts a value to uppercase
Modifies the structure of a table
Sets the value of a variable in the current session
Adds a new column to a table
Deletes records from a table