To concatenate two or more strings
To count the number of characters in a string
To find the position of a substring in a string
To convert a string to uppercase
DROP PRIMARY KEY
REMOVE PRIMARY KEY
ALTER TABLE
DELETE PRIMARY KEY
Atomicity, Consistency, Isolation, Durability
Aggregate, Consistency, Isolation, Durability
Atomic, Consistent, Isolated, Durable
Association, Consistency, Isolation, Durability
DROP FOREIGN KEY
REMOVE FOREIGN KEY
DELETE FOREIGN KEY
To round a numeric value to the nearest integer
To generate a random number
To retrieve a random record from a table
To rank rows based on a specified column
To sort the result set in ascending order
To filter rows based on a condition
To provide subtotals and grand totals in the result set
To limit the number of rows in the result set
To lock a table for read access only
To lock a table for write access only
To lock one or more tables for specific operations
To unlock all tables in the database
TOUPPER()
LOWER()
LCASE()
CONVERT()
To find the maximum value among a set of values
To find the minimum value among a set of values
To concatenate strings
To calculate the average value of a set of values
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 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