Reserved Words in MySQL
Here are some commonly used reserved words in MySQL and their meaning.
- SELECT: Used to retrieve data from one or more database tables.
- INSERT: Used to insert new records into a database table.
- UPDATE: Used to modify existing records in a database table.
- DELETE: Used to delete specific records from a database table.
- CREATE: Used to create a new database, table, or other database objects.
- ALTER: Used to modify the structure of an existing database object.
- DROP: Used to delete or remove a database object.
- WHERE: Used to filter data based on specific conditions in a query.
- JOIN: Used to combine rows from two or more tables based on a related column.
- FROM: Specifies the data source for the SELECT statement, indicating the table(s) from which to retrieve data.
- ORDER BY: Sorts the result set in ascending or descending order based on one or more columns.
- GROUP BY: Groups the result set by one or more columns, typically used with aggregate functions like SUM, COUNT, etc.
- HAVING: Filters the grouped result set based on specified conditions, similar to the WHERE clause but applied after the GROUP BY operation.
- LIMIT: Limits the number of rows returned by a SELECT statement.
- INNER JOIN: Retrieves records that have matching values in both tables being joined.
- LEFT JOIN: Retrieves all records from the left table and the matched records from the right table.
- RIGHT JOIN: Retrieves all records from the right table and the matched records from the left table.
- FULL JOIN: Retrieves all records when there is a match in either the left or right table.
- DISTINCT: Filters out duplicate rows from the result set.
- UNION: Combines the result sets of two or more SELECT statements into a single result set.
MySQL Reserved Words
MySQL is a popular and widely used Relational Database Management System. Like any programming language, MySQL has its own set of reserved words. Reserved words are specific terms or keywords with predefined meanings within the database system. It is very important to know the reserved words to avoid conflicts in the execution of the queries.
Contact Us