GRANT SELECT ON database.* TO user;
GRANT ALL PRIVILEGES ON database.* TO user;
GRANT DATABASE SELECT TO user;
GRANT USER SELECT ON database.*;
Retrieves the previous value in a result set based on a specified order
Returns the next value in a result set based on a specified order
Calculates the average value for each group of rows
Counts the number of rows in a result set
A key used for sorting the table
A unique identifier for a record in a table
A key used for encryption
A column or set of columns that refers to the primary key of another table
ALTER TYPE
MODIFY COLUMN
CHANGE COLUMN
ALTER TABLE
Returns the first non-null expression among its arguments
Compares two expressions and returns null if they are equal
Converts a value to uppercase
Concatenates two or more strings
WHERE
GROUP
FILTER
CONDITION
Rounds a numeric value to the nearest integer
Formats a date or numeric value according to a specified format
Converts a string to lowercase
Retrieves the length of a string
DENY ALL PRIVILEGES
REVOKE ALL
REVOKE ALL PRIVILEGES
DELETE PRIVILEGES
A function that increments a numeric value by a specified step
A constraint used for sorting the table
A unique identifier for a record in a table that increments automatically
A command to increment the value of a column
Removes all rows from a table
Trims leading and trailing spaces from a string
Deletes a specific record from a table
ALTER COLUMN
CONVERT COLUMN
Assigns a unique number to each row in a result set
Counts the total number of rows in a table
Orders the rows in a result set
Retrieves the maximum value in a column
Resets the database engine
Clears the query cache
Reloads the privilege tables
Drops all indexes from a table
CURRENT_USER()
USER_NAME()
SESSION_USER()
SYSTEM_USER()
Removes a specific column from a table
Extracts a substring from a string
Extracts a part (year, month, day, etc.) from a date or time
Extracts a numeric value from a column
GROUP BY
JOIN
HAVING
Manages user-defined functions
Controls error handling in stored procedures
Handles exceptions in transactions
Manages event scheduling
Performs a left outer join between tables
CREATE INDEX
MAKE INDEX
UNIQUE INDEX
ADD INDEX
Repeats a string a specified number of times
Returns the position of a substring in a string
