Arithmetic operators in MySQL Database

Arithmetic operators in MySQL database

An overview of operators:

Operator is also an important body of knowledge in MySQL databases, and it is very helpful to manipulate data when executing sql statements. The use of operators can help you save a lot of time, and it is more flexible to operate.

II. Operator

Operators mainly include "arithmetic operator", "comparison operator", "Luo operator", "bit operator" four categories, let's learn it at once.

1. Arithmetic operator

Arithmetic operators are often used in sql statements, such as field operations on tables, and so on.

2. Comparison operator

The more tired operator is a more important part, and you need to focus on the part of the tag

3. Logical operator

Logical operator is a frequently used operator when manipulating table data, so we need to grasp the key points.

4. Bit operator

The bit operator is actually a query you may use to intercept data, constantly splicing a lot of data.

Fourth, the finite order of operators

Priority, that is, who is executed first when there are two or more operators in a sql. This is also a very important content.

Precedence operators 1, 2-3 ^ 4 *, /, div,%, mod5+,-6 > >,