资源描述：
《《MySQL中的运算符》PPT课件.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、第四章MySQL中的运算符算术运算符比较运算符逻辑运算符位运算符4.1算术运算符运算符作用+加法-减法*乘法/，DIV除法，返回商%，MOD除法，返回余数Mysql>select0.1+0.3333,0.1-0.3333,0.1*0.3333,1/2,1%2;Mysql>select1/0,100%0;Mysql>select3%2,mod(3,2);4.2比较运算符运算符作用=等于<>或!=不等于<=>安全的等于<小于<=小于等于>大于>=大于等于BETWEEN存在于指定范围IN存在于指定集合ISNULL为NULLISNOTNU
2、LL不为NULLLIKE通配符匹配REGEXP或RLIKE正则表达式匹配=Mysql>select1=0,1=1,null=null;<>Mysql>select1<>0,1<>1,null<>null;<=>Mysql>select1<=>1,2<=>0,0<=>0,null<=>null;select‘a’<‘b’,’a’<‘a’,’a’<‘c’,1<2;<=Mysql>select‘bdf’>’b’,’b’,<=‘b’,0<1;>Mysql>select‘a’>’b’,’abc’>’a’,1>0;>=Mysql
3、>select‘a’>=’b’,’abc’>=’a’,1>=0,1>=1;BetweenMysql>select10between9and20,15between10and20;InMysql>select1in(1,2,3),’t’in(‘t’,’a’,’b’,’l’,’e’);IsnullMysql>select0isnull,nullisnull;IsnotnullMysql>select0isnotnull,nullisnotnull;LikeMysql>select123456like‘123%’,123456like‘
4、%123%’,123456like‘%32%1’;RegexpMysql>select‘abcdef’regexp‘ab’,’abcdefg’regexp‘k’;4.3逻辑运算符运算符作用NOT!逻辑非AND&&逻辑与OR
5、
6、逻辑或XOR逻辑异或NOT!Mysql>selectnot0,not1,notnull;AND&&Mysql>select(1and1),(1and0),(3and1),(1andnull);OR
7、
8、Mysql>select(1or0),(0or0),(1ornull),(1or1l),(nullornull
9、);XORMysql>select1xor1,0xor0,1xor0,0xor1,nullxor1;4.4位运算符运算符作用&位于
10、位或^位异或~位取反》位右移《位左移Mysql>select2&3;Mysql>select2&3&4;Mysql>select2
11、3;Mysql>select2^3;Mysql>select~1,~18446744073709551614;Mysql>selectbin(18446744073709551614);Mysql>select100>>3;Mysql>select100<<3;4.5运算
12、符的优先级优先级顺序运算符1:=2
13、
14、,OR,XOR3&&,AND4NOT5BETWEEN,CASE,WHEN,THEN,ELSE6=,<=>,>=,>,<=,<,<>,!=,IS,LIKE,REGEXP,IN7
15、8&9<<,>>10-,+11*,/,DIV,%,MOD12^13-,~14!
