《MySQL中的运算符.ppt》由会员分享,可在线阅读,更多相关《MySQL中的运算符.ppt(17页珍藏版)》请在三一办公上搜索。
1、第四章MySQL中的运算符,算术运算符比较运算符逻辑运算符位运算符,4.1 算术运算符,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 比较运算符,=Mysqlselect 1=0,1=1,null=null;Mysqlselect 10,11,nullnull;Mysqlselect 11,20,00,nullnull;,select aselect bdfb,b,=b,01;,Mysqlselect ab,abca,10;=Mys
2、qlselect a=b,abc=a,1=0,1=1;,BetweenMysqlselect 10 between 9 and 20,15 between 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 逻辑运算符,NOT!Mysqlselect not 0,not 1,not null;AND,4.4 位运算符,Mysqlselect 2,Mysqlselect 1003;Mysqlselect 1003;,4.5 运算符的优先级,