第四章 MySQL中的孕滤算符.pptVIP

第四章 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 1=1,2=0,0=0,null=null;; Mysqlselect ‘a’‘b’,’a’‘a’,’a’‘c’,12; = Mysqlselect ‘bdf’’b’,’b’,=‘b’,01;; Mysqlselect ‘a’’b’,’abc’’a’,10; = Mysqlselect ‘a’=’b’,’abc’=’a’,1=0,1=1;;Between Mysqlselect 10 between 9 and 20,15 between 10 and 20; In Mysqlselect 1 in(1,2,3),’t’ in(‘t’,’a’,’b’,’l’,’e’);;Is null Mysqlselect 0 is null,null is null; Is not null Mysqlselect 0 is