DROP INDEX
REMOVE INDEX
DELETE INDEX
ERASE INDEX
Returns the current date and time
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()
Removes leading and trailing spaces from a string
Concatenates two or more strings
Converts a string to uppercase
Rounds a numeric value to the nearest integer
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
ALTER TABLE
MODIFY COLUMN
CHANGE COLUMN
UPDATE TABLE
Retrieves the sound of a column value
Retrieves a specific substring from a string
Converts a string to a phonetic code
TOTAL ROWS
COUNT ROWS
NUMROWS
SELECT COUNT(*)
Truncates a string to a specified length
Extracts a substring from a string
Replaces a specified substring with another substring
ADD PRIMARY KEY
CREATE PRIMARY KEY
SET PRIMARY KEY
PRIMARY KEY TABLE
To lock a specific row in a table
To prevent other sessions from accessing a table for a specific purpose
To modify the structure of a table
To unlock a table for other sessions
USER()
CURRENT_USER()
HOST_USER()
SESSION_USER()
Checks if a value is NULL
Converts a value to uppercase
Returns the first non-null expression among its arguments
Calculates the average value for a column
To discard all changes made in a transaction
To refresh the table cache
To delete all records from a table
To optimize and flush the changes to disk for all tables
ALTER TYPE
ALTER COLUMN
Enables foreign key checks for the entire database
Deletes all foreign keys from a table
Modifies the structure of a foreign key
Converts a value to binary
Returns the binary representation of a string
Retrieves the last inserted binary data
Checks if a value is binary
FIND()
SEARCH()
Removes all records from a table
Trims leading and trailing spaces from a string
Truncates a table structure
Performs mathematical operations on numeric values
