《《MySQL中的运算符》PPT课件.ppt》由会员分享,可在线阅读,更多相关《《MySQL中的运算符》PPT课件.ppt(17页珍藏版)》请在金锄头文库上搜索。
1、第四章第四章MySQLMySQL中的运算符中的运算符算术运算符算术运算符比较运算符比较运算符逻辑运算符逻辑运算符位运算符位运算符4.1 4.1 算术运算符算术运算符运运 算算 符符作作 用用+加法加法-减法减法*乘法乘法/,DIV除法,返回商除法,返回商%,MOD除法,返回余数除法,返回余数Mysqlselect 0.1+0.3333,0.1-0.3333,0.1*0.3333,1/2,1%2;Mysqlselect 1/0,100%0;Mysqlselect 3%2,mod(3,2);4.2 4.2 比较运算符比较运算符运算符运算符作作 用用=等于或!=不等于安全的等于小于大于=大于等于BE
2、TWEEN存在于指定范围IN存在于指定集合IS NULL为NULLIS NOT NULL不为NULLLIKE通配符匹配REGEXP或RLIKE正则表达式匹配=Mysqlselect 1=0,1=1,null=null;Mysqlselect 10,11,nullnull;Mysqlselect 11,20,00,nullnull;select ab,aa,ac,12;select bdfb,b,=b,0Mysqlselect ab,abca,10;=Mysqlselect a=b,abc=a,1=0,1=1;BetweenMysqlselect 10 between 9 and 20,15 b
3、etween 10 and 20;InMysqlselect 1 in(1,2,3),t in(t,a,b,l,e);Is nullMysqlselect 0 is null,null is null;Is not nullMysqlselect 0 is not null,null is not null;LikeMysqlselect 123456 like 123%, 123456 like %123%, 123456 like %32%1;RegexpMysqlselect abcdef regexp ab, abcdefg regexp k;4.3 4.3 逻辑运算符逻辑运算符运算符
4、运算符作作 用用NOT !逻辑非AND &逻辑与OR |逻辑或XOR逻辑异或NOT !Mysqlselect not 0,not 1,not null;AND &Mysqlselect (1 and 1),(1 and 0),(3 and 1),(1 and null);OR |Mysqlselect (1 or 0),(0 or 0),(1 or null),(1 or 1l),(null or null);XORMysqlselect 1 xor 1,0 xor 0,1 xor 0,0 xor 1,null xor 1;4.4 4.4 位运算符位运算符运算符运算符作作 用用&位于|位或位异
5、或位取反位右移位左移Mysqlselect 2&3;Mysqlselect 2&3&4;Mysqlselect 2|3;Mysqlselect 23;Mysqlselect 1,18446744073709551614;Mysqlselect bin(18446744073709551614);Mysqlselect 1003;Mysqlselect 1003;4.5 4.5 运算符的优先级运算符的优先级优先级顺序优先级顺序运运 算算 符符1:=2|,OR,XOR3&,AND4NOT5BETWEEN,CASE,WHEN,THEN,ELSE6=,=,=,!=,IS,LIKE,REGEXP,IN7|8&910-,+11*,/,DIV,%,MOD1213-,14!