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
CHANGE COLUMN
ALTER COLUMN TYPE
MODIFY COLUMN
UPDATE COLUMN TYPE
LENGTH()
CHAR_LENGTH()
STRLEN()
LEN()
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
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
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
REVOKE
REMOVE PRIVILEGES
DELETE 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
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
DROP TABLE
DELETE TABLE
REMOVE TABLE
ERASE TABLE
CREATE VIEW
MAKE VIEW
VIEW TABLE
DEFINE VIEW
To retrieve all rows from both tables, even if there is no match
To retrieve only the common rows between two tables based on a related column
To retrieve rows from the first table only
To retrieve rows from the second table only
CREATE INDEX
MAKE INDEX
INDEX TABLE
DEFINE INDEX
To retrieve data from a table
To describe the structure of a database
To create a new table
To show the structure of a table
To perform conditional logic within a query
To join tables based on a condition
LIKE
MATCH
CONTAINS
COMPARE
AND
OR
NOT
XOR
To retrieve rows from the first table and matching rows from the second table
To retrieve rows from the second table and matching rows from the first table
