Geek Slack

  • September 18, 2024
  • 8:11 PM
Facebook Linkedin
Course Content
MySQL
0/33
MySQL Basics
00:00
MySQL SELECT
00:00
MySQL WHERE
00:00
MySQL AND, OR & NOT
00:00
MySQL ORDER BY
00:00
MySQL INSERT INTO
00:00
MySQL NULL
00:00
MySQL UPDATE
00:00
MySQL DELETE
00:00
MySQL LIMIT
00:00
MySQL MIN() and MAX()
00:00
MySQL COUNT, AVG and SUM
00:00
MySQL LIKE
00:00
MySQL Wildcards
00:00
MySQL IN
00:00
MySQL BETWEEN
00:00
MySQL Aliases
00:00
MySQL Joins
00:00
MySQL INNER JOIN
00:00
MySQL LEFT JOIN
00:00
MySQL RIGHT JOIN
00:00
MySQL CROSS JOIN
00:00
MySQL Self Join
00:00
MySQL UNION
00:00
MYSQL GROUP BY
00:00
MySQL HAVING Clause
00:00
MySQL EXISTS
00:00
MySQL ANY, ALL
00:00
MySQL INSERT INTO
00:00
MySQL CASE Statement
00:00
MySQL NULL Functions
00:00
MySQL Comments
00:00
MySQL Operators
00:00
My SQL Tutorial
About Lesson


MySQL Operators


MySQL Operators

Operators in MySQL are used to perform operations on values and produce a result. They include arithmetic operators, comparison operators, logical operators, and more.

Arithmetic Operators:

SELECT 10 + 5 AS addition,
       10 - 5 AS subtraction,
       10 * 5 AS multiplication,
       10 / 5 AS division,
       10 % 3 AS modulus;

This query demonstrates the arithmetic operators in MySQL, including addition, subtraction, multiplication, division, and modulus.

Comparison Operators:

SELECT * FROM employees
WHERE salary > 5000;

This query selects all employees with a salary greater than 5000, using the comparison operator >.

Logical Operators:

SELECT * FROM employees
WHERE department_id = 1 AND salary > 5000;

This query selects employees from department 1 with a salary greater than 5000, using the logical AND operator.

These are just a few examples of operators in MySQL. They are essential for building complex queries and performing various operations on data.

Join the conversation
Previous
Next