mysql中的运算符分为四类:
算术运算符(+,-,*,/,div整除)
比较(= != >= <= true 1 false 0)
逻辑(and or !)
位运算符 & | ^
算术运算符
select 1+1;
select 1-1;
select 1*2;
select 3/2; # 1.5
select 3 div 2; #整除
select 3/0; # null
比较运算符 = != >= <= true 1 false 0
select 1!=1;
# is null / is not null / between …and …/ in / not in
逻辑运算符 and or !
select 1=1 and 1=2;
select 1=1 or 1=2;
select !1=1;
位运算符 & | ^
select 3 & 2; # 2
select 3 | 2; # 3
select 3 ^ 2; # 1