Returns the next value in a result set based on a specified order
Counts the number of rows in a result set
Retrieves the previous value in a result set based on a specified order
Performs a left outer join between tables
DROP TABLE
DELETE TABLE
REMOVE TABLE
ERASE TABLE
Grants the user all privileges on all databases from any host
Grants the user all privileges on a specific database from any host
Grants the user specific privileges on all databases from a specific host
Grants the user permission to create a new database
CONCAT()
COMBINE()
MERGE()
JOIN()
Generates a random number without any seed value
Generates a random number based on a specified seed value
Generates a random string
Retrieves a random record from a table
Concatenates rows into a single string based on a specified condition
Groups rows based on a columns values
Retrieves the minimum value in a column
ADD UNIQUE
UNIQUE COLUMN
SET UNIQUE
CREATE UNIQUE
Returns the current date and time
Returns the username of the current user
Retrieves the maximum value in a column
Displays the structure of a database
Displays a list of all databases in the server
Creates a new database
Shows the relationships between tables
LCASE()
LOWER()
CONVERT()
TOLOWER()
Combines rows from two or more tables based on a related column
Retrieves all rows from both tables, regardless of a match
Performs a join operation with a condition
Creates a Cartesian product of two tables
RENAME COLUMN
ALTER COLUMN
CHANGE COLUMN
MODIFY COLUMN
Shows the structure of an index
Displays a list of all indexes in a database
Shows the indexes associated with a specific table
Deletes an index from a table
Provides information about the execution plan of a query
Exports data from a table
Adds explanatory comments to a query
Lists all foreign keys in a database
Retrieves the last record in a table
Returns the last ID generated by an AUTO_INCREMENT column
Retrieves the last value in a column
Returns the last date and time a record was modified
Filters rows based on a condition before grouping
Groups rows based on a condition
Applies a condition to individual records after grouping
Sorts the result set in descending order
Returns the current date
Converts a string to lowercase
Retrieves the highest value in a column
Disables foreign key checks for the current session
Sets the foreign key values to zero in the specified table
Removes all foreign key constraints from the database
Sets the value of a foreign key column to zero
POSITION()
LOCATE()
SUBSTRING_INDEX()
STRPOS()
Refreshes the database indexes
Removes all privileges from a user
Reloads the privileges from the grant tables in the mysql system database
Deletes all records from a table
