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
INSERT INTO
ADD RECORD
UPDATE
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
MIN()
LEAST()
SMALL()
LOWER()
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()
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
