MySQL
- Introduction To MySQL
- MySQL RDBMS
- MySQL SQL
- MySQL SELECT Statement
- MySQL WHERE Clause
- MySQL AND, OR And NOT Operators
- MySQL ORDER BY Keyword
- MySQL INSERT INTO Statement
- MySQL NULL Values
- MySQL UPDATE Statement
- MySQL DELETE Statement
- MySQL LIMIT Clause
- MySQL MIN() And MAX() Functions
- MySQL COUNT(), AVG() And SUM() Functions
- MySQL LIKE Operator
- MySQL Wildcards
- MySQL IN Operator
- MySQL BETWEEN
- MySQL Aliases
- MySQL Joins
- MySQL INNER JOIN Keyword
- MySQL LEFT JOIN Keyword
- MySQL RIGHT JOIN Keyword
- MySQL CROSS JOIN Keyword
- MySQL Self Join
- MySQL UNION Operator
- MySQL GROUP BY Statement
- MySQL HAVING Clause
- MySQL EXISTS Operator
- MySQL ANY And ALL Operators
- MySQL INSERT INTO SELECT Statement
- MySQL CASE Statement
- MySQL NULL Functions
- MySQL Comments
- MySQL Operators
- MySQL CREATE DATABASE Statement
- MySQL DROP DATABASE Statement
- MySQL CREATE TABLE Statement
- MySQL DROP TABLE Statement
- MySQL ALTER TABLE Statement
- MySQL Constraints
- MySQL NOT NULL Constraint
- MySQL UNIQUE Constraint
- MySQL PRIMARY KEY Constraint
- MySQL FOREIGN KEY Constraint
- MySQL CHECK Constraint
- MySQL DEFAULT Constraint
- MySQL CREATE INDEX Statement
- MySQL AUTO INCREMENT Field
- MySQL Working With Dates
- MySQL Views
- MySQL Data Types
- MySQL Functions
MySQL Operators
Ad
MySQL Arithmetic Operators
Operator | Description | Example |
---|---|---|
+ | Add | Try it |
- | Subtract | Try it |
* | Multiply | Try it |
/ | Divide | Try it |
% | Modulo | Try it |
Practice Excercise Practice now
MySQL Bitwise Operators
Operator | Description |
---|---|
& | Bitwise AND |
| | Bitwise OR |
^ | Bitwise exclusive OR |
Practice Excercise Practice now
MySQL Compound Operators
Operator | Description |
---|---|
+= | Add equals |
-= | Subtract equals |
*= | Multiply equals |
/= | Divide equals |
%= | Modulo equals |
&= | Bitwise AND equals |
^-= | Bitwise exclusive equals |
|*= | Bitwise OR equals |
Practice Excercise Practice now
MySQL Logical Operators
Operator | Description | Example |
---|---|---|
ALL | TRUE if all of the subquery values meet the condition | Try it |
AND | TRUE if all the conditions separated by AND is TRUE | Try it |
ANY | TRUE if any of the subquery values meet the condition | Try it |
BETWEEN | TRUE if the operand is within the range of comparisons | Try it |
EXISTS | TRUE if the subquery returns one or more records | Try it |
IN | TRUE if the operand is equal to one of a list of expressions | Try it |
LIKE | TRUE if the operand matches a pattern | Try it |
NOT | Displays a record if the condition(s) is NOT TRUE | Try it |
OR | TRUE if any of the conditions separated by OR is TRUE | Try it |
SOME | TRUE if any of the subquery values meet the condition | Try it |
Practice Excercise Practice now