Arithmetic operators in the MySQL database

Arithmetic operators in the MySQL database

Arithmetic operators in the MySQL database

First, an overview of the operators:

The operator is also an important knowledge body in the MySQL database, which is very useful for manipulating data when executing SQL statements. The use of these operators can help you save a lot of time, and more flexible operation.

Second, operator

Operators mainly include "arithmetic operator", "comparison operator", "Luo operator", "bitwise operator" Four categories, next we will learn a bit.

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/06/F7/wKiom1nBHnjRiJiaAAA-_uRmsFs021.jpg "title=" MySQL arithmetic operator. jpg "alt=" wkiom1nbhnjrijiaaaa-_urmsfs021.jpg "/>

1. Arithmetic operators

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

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/06/F7/wKiom1nBHuLAt78AAAAsitkg64c307.jpg "title=" 1, Arithmetic operator. jpg "alt=" wkiom1nbhulat78aaaasitkg64c307.jpg "/>

2. Comparison operators

Comparing the tired operators is an important part, you need to focus on the parts of the tag

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/06/F7/wKiom1nBHyuyMPzsAACz_sJINqE267.jpg "title=" 2, comparison operator. jpg "alt=" wkiom1nbhyuympzsaacz_sjinqe267.jpg "/>

3. Logical operators

A logical operator is an operator that uses more frequently when manipulating table data and needs to focus

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/06/F7/wKiom1nBH4XgLpwEAABD6DktcGM072.jpg "title=" 3, logical operator. jpg "alt=" wkiom1nbh4xglpweaabd6dktcgm072.jpg "/>

4, bitwise operators

Bit operators are actually the data you can use when you intercept a query, and constantly splicing a lot of data.

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/06/F7/wKiom1nBH-HSCToZAABTgQTFh_w198.jpg "title=" 4, bitwise operator. jpg "alt=" wkiom1nbh-hsctozaabtgqtfh_w198.jpg "/>

Iv. finite levels of operators

Priority level that is, when there are 2 or more operators in a SQL, who takes precedence over the execution. This is also a very important part of the content.

Priority Level	Operator
1	!
2	~
3	^
4	*,/, Div,%, mod
5	+,-
6	>>, <<
7	&
8	|
9	=, <=>, <, <=, >, >=,! =, <>, in, is, null, link, regexp

10	Between and, case, when, then, else
11	Not
12	&&, and
13	| |, or, and
14	:=

V. Concluding remarks:

Here we go. Specific operators, these operators in our subsequent SQL operations will be a great channel of help, through which we can accurately query to a field and so on. Learn well! Come on!

This article from "Lonely One Night" blog, reproduced please contact the author!

Arithmetic operators in the MySQL database