NOW()
CURRENT_DATE()
GETDATE()
SYSDATE()
To automatically execute a set of SQL statements when a specific event occurs
To create a temporary table
To delete records from a table
To modify the structure of a table
TOUPPER()
LOWER()
LCASE()
CONVERT()
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
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
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
