当前位置:Gxlcms > 数据库问题 > SQL之运算符操作

SQL之运算符操作

时间:2021-07-01 10:21:17 帮助过:2人阅读

6+4 加法操作,     6-4 减法操作,     6*4 乘法操作,     6/2 除法操作,     6 DIV 2 除法操作,     6%4 求模操作,     6 MOD 4 求模操作;

技术分享

除此之外,还可以直接对表中的属性进行操作:

  1. <span style="color: #0000ff;">SELECT</span> ename 雇员,sal  月工资,sal<span style="color: #808080;">*</span><span style="color: #800000; font-weight: bold;">12</span><span style="color: #000000;"> 年薪
  2.     </span><span style="color: #0000ff;">FROM</span> t_employee;

技术分享

 比较运算符:

如果符合条件,返回1,否则返回0;

  1. <span style="color: #0000ff;">SELECT</span> <span style="color: #800000; font-weight: bold;">1</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;">   数值比较,
  2.     </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">cjgong</span><span style="color: #ff0000;">‘</span><span style="color: #808080;">=</span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">cjgong</span><span style="color: #ff0000;">‘</span><span style="color: #000000;"> 字符串比较,
  3.     </span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">2</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span><span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">3</span><span style="color: #000000;"> 表达式比较,
  4.     </span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #808080;"><=></span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;">   数值比较,
  5.     </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">cjgong</span><span style="color: #ff0000;">‘</span><span style="color: #808080;"><=></span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">cjgong</span><span style="color: #ff0000;">‘</span><span style="color: #000000;"> 字符串比较,
  6.     </span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">2</span><span style="color: #808080;"><=></span><span style="color: #800000; font-weight: bold;">3</span><span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">3</span> 表达式比较;

技术分享

除此之外可以在where语句中使用:

技术分享

逻辑运算符:在where中用逻辑运算可以进行条件组合。

真和NULL与还是NULL

  1. <span style="color: #0000ff;">SELECT</span> <span style="color: #800000; font-weight: bold;">3</span> <span style="color: #808080;">AND</span> <span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">,
  2.     </span><span style="color: #800000; font-weight: bold;">0</span> <span style="color: #808080;">AND</span> <span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">,
  3.     </span><span style="color: #800000; font-weight: bold;">0</span> <span style="color: #808080;">AND</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  4.     </span><span style="color: #800000; font-weight: bold;">3</span> <span style="color: #808080;">AND</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  5.     </span><span style="color: #800000; font-weight: bold;">3</span> <span style="color: #808080;">&&</span> <span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">,
  6.     </span><span style="color: #800000; font-weight: bold;">0</span> <span style="color: #808080;">&&</span> <span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">,
  7.     </span><span style="color: #800000; font-weight: bold;">0</span> <span style="color: #808080;">&&</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  8.     </span><span style="color: #800000; font-weight: bold;">3</span> <span style="color: #808080;">&&</span> <span style="color: #0000ff;">NULL</span>;

 

  1. <span style="color: #0000ff;">SELECT</span> filed <span style="color: #0000ff;">from</span> table_name <span style="color: #0000ff;">where</span> col1<span style="color: #808080;">=</span>x <span style="color: #808080;">and</span> col2 <span style="color: #808080;">=</span>x <span style="color: #808080;">or</span> col3<span style="color: #808080;">></span><span style="color: #800000; font-weight: bold;">10</span>

 

 位运算符:

bin函数可以查看二进制:

  1. <span style="color: #0000ff;">SELECT</span> <span style="color: #800000; font-weight: bold;">5</span><span style="color: #808080;">&</span><span style="color: #800000; font-weight: bold;">6</span> , BIN(<span style="color: #800000; font-weight: bold;">5</span><span style="color: #808080;">&</span><span style="color: #800000; font-weight: bold;">6</span><span style="color: #000000;">) 二进制数,
  2.     </span><span style="color: #800000; font-weight: bold;">4</span><span style="color: #808080;">&</span><span style="color: #800000; font-weight: bold;">5</span><span style="color: #808080;">&</span><span style="color: #800000; font-weight: bold;">6</span>,BIN(<span style="color: #800000; font-weight: bold;">4</span><span style="color: #808080;">&</span><span style="color: #800000; font-weight: bold;">5</span><span style="color: #808080;">&</span><span style="color: #800000; font-weight: bold;">6</span>) 二进制数;

 

 技术分享

  1. <span style="color: #0000ff;">SELECT</span> <span style="color: #800000; font-weight: bold;">3</span> XOR <span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">,
  2.     </span><span style="color: #800000; font-weight: bold;">0</span> XOR <span style="color: #800000; font-weight: bold;">0</span><span style="color: #000000;">,
  3.     </span><span style="color: #0000ff;">NULL</span> XOR <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  4.     </span><span style="color: #800000; font-weight: bold;">0</span> XOR <span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">,
  5.     </span><span style="color: #800000; font-weight: bold;">0</span> XOR <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  6.     </span><span style="color: #800000; font-weight: bold;">3</span> XOR <span style="color: #0000ff;">NULL</span>;

 

NULL和任何数据XOR返回NULL

技术分享

 

SQL之运算符操作

标签:

人气教程排行