摄影网站的模板,温州网站建设公司公司哪家好,设计产品网站推荐,赚钱软件下载原文#xff1a;http://www.jb51.net/article/25657.htm我一贯秉承着一点#xff1a;通过自己的双手真实的操作一遍之后的信息是最可靠的#xff0c;所以在您参考这个小文儿的时候请不要只是“看”#xff0c;单纯的瞧一瞧是得不到真知滴~~~座右铭#xff1a;纸上得来终觉…原文http://www.jb51.net/article/25657.htm我一贯秉承着一点通过自己的双手真实的操作一遍之后的信息是最可靠的所以在您参考这个小文儿的时候请不要只是“看”单纯的瞧一瞧是得不到真知滴~~~座右铭纸上得来终觉浅绝知此事要躬行1.算数运算符加mysql select 12;减mysql select 2-1;乘mysql select 2*3;除mysql select 5/3;商mysql SELECT 5 DIV 2;模mysql select 5%2,mod(5,2);2.比较运算符等于mysql select 10,11,nullnull;不等于mysql select 10,11,nullnull;安全等于mysql select 11,20,00,nullnull;小于mysql select ‘a’小于等于mysql select ‘bdf’’b’,’b’’b’,01;大于mysql select ‘a’’b’,’abc’’a’,10;大于等于mysql select ‘a’’b’,’abc’’a’,10,11;BETWEENmysql select 10 between 10 and 20, 9 between 10 and 20;INmysql select 1 in (1,2,3), ‘t’ in (‘t’,’a’,’b’,’l’,’e’), 0 in (1,2);IS NULLmysql select 0 is null,null is null;IS NOT NULLmysql select 0 is not null, null is not null;LIKEmysql select 123456 like ‘123%’, 123456 like ‘%123%’, 123456 like ‘%321%’;REGEXPmysql select ‘abcdef’ regexp ‘ab’, ‘abcdefg’ regexp ‘k’;3.逻辑运算符非mysql select not 0, not 1, not null;mysql select ! 0, ! 1, ! null;与mysql select (1 and 1), (0 and 1), (3 and 1), (1 and null);mysql select (1 1), (0 1), (3 1), (1 null);或mysql select (1 or 0), (0 or 0), (1 or null), (1 or 1), (null or null);mysql select (1 || 0), (0 || 0), (1 || null), (1 || 1), (null || null);异或mysql select (1 xor 1), (0 xor 0), (1 xor 0), (0 xor 1), (null xor 1);mysql select (1 ^ 1), (0 ^ 0), (1 ^ 0), (0 ^ 1), (null ^ 1);4.位运算符位与mysql select 23;mysql select 234;位或mysql select 2|3;位异或mysql select 2^3;位取反mysql select ~1,~18446744073709551614;位右移mysql select 1003;位左移mysql select 1003;5.运算符优先级顺序最高优先级 :1 ||, OR, XOR2 , AND3 BETWEEN, CASE, WHEN, THEN, ELSE4 , , , , , , !, IS, LIKE, REGEXP, IN5 |6 7 8 -, 9 *, /, DIV, %, MOD10 ^11 - (unary minus), ~ (unary bit inversion)12 !, NOT最低优先级 BINARY, COLLATE好运。– The End –
