MySQL is a popular relational database management system used to store and manage data. Here are some common SQL queries with examples and explanations:
1. SELECT Query:
- Example: `SELECT * FROM employees;`
- Explanation: This query retrieves all columns (`*`) from the "employees" table, returning all rows.
2. WHERE Clause:
- Example: `SELECT * FROM employees WHERE department = 'HR';`
- Explanation: This query retrieves all columns from the "employees" table where the "department" column has the value 'HR'.
3. ORDER BY Clause:
- Example: `SELECT * FROM employees ORDER BY salary DESC;`
- Explanation: This query retrieves all columns from the "employees" table and sorts the result in descending order based on the "salary" column.
4. INSERT INTO Query:
- Example: `INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT');`
- Explanation: This query inserts a new record into the "employees" table with specified values for the "name", "age", and "department" columns.
5. UPDATE Query:
- Example: `UPDATE employees SET salary = 50000 WHERE department = 'Finance';`
- Explanation: This query updates the "salary" column to 50000 for all rows in the "employees" table where the "department" column has the value 'Finance'.
6. DELETE Query:
- Example: `DELETE FROM employees WHERE age > 60;`
- Explanation: This query deletes all rows from the "employees" table where the "age" column is greater than 60.
7. JOIN Clause:
- Example: `SELECT employees.name, departments.department_name FROM employees JOIN departments ON employees.department_id = departments.id;`
- Explanation: This query retrieves the "name" column from the "employees" table and the "department_name" column from the "departments" table, joining them based on the "department_id" and "id" columns, respectively.
These are just a few examples of MySQL queries. Remember that SQL syntax may vary slightly depending on the specific database system you are using, but the principles remain consistent.
Comments
Post a Comment