MySQL基础2

1.运算符

1.1 算术运算符 + - * /

select 1+1;   #2
select 1-1;   #0
select 1*1;   #1
select 5/2;   #2.5 
select 3/0;   #null(空)
select 5 div 2; #取整
select 5%2;   #取模(余)运算

1.2 比较运算符 = > < >= <= / != <>

结果?  true--> 1    /    false ---> 0
select 1=1;   #1
select 1!=1;  #0
select 1<>1;  #0

1.3 逻辑运算符 and or !