PHP学习之SQL语句快速入门
网络编程 2021-07-05 15:27www.168986.cn编程入门
在学校php过程中,需要用得到的一些语句。比较简单的大家一定要掌握啊。
Select from tablename
SQL> select from employees;
Select select list from tablename
SQL> select employee_id,first_name from employees;
Select distinct … from tablename
SQL> select distinct manager_id from employees;
||连接符使用以及 加减乘除以及括号的使用
SQL> select employee_id,first_name||'.'||last_name,salary(1+0.1)/100,manager_id
2 from employees;
+-做正负号使用
SQL> select -salary from employees;
<>,>,<,=,!=等比较操作符
SQL> select from employees where salary >13000;
SQL> select from employees where salary <13000;
SQL> select from employees where salary <>13000;
SQL> select from employees where salary =13000;
In
SQL> select -salary from employees where employee_id in (100,101,102);
SQL> select -salary from employees where employee_id in (select employee_id from employees);
not in
SQL> select -salary from employees where employee_id not in (100,101,102);
Any(比任意一个都)
select from employees where employee_id >any(100,101,102);
some 是 SQL-92 标准的 any 的等效物
select from employees where employee_id >any(100,101,102);
all(比所有的都)
select from employees where employee_id >all(100,101,102);
between and
select from employees where employee_id between 100 and 102;
not between and
select from employees where employee_id not between 100 and 102;
逻辑操作符
And 和 or
select from employees where employee_id > 100 and employee_id < 1000;
select from employees where employee_id > 100 or employee_id < 1000;
Order by
Desc
select from employees where employee_id between 100 and 102 order by employee_id desc;
Asc
select from employees where employee_id between 100 and 102 order by employee_id asc;
dual哑元表没有表需要查询的时候可以用它
select sysdate from dual;
select 12345 from dual;
SQL> select from employees;
Select select list from tablename
SQL> select employee_id,first_name from employees;
Select distinct … from tablename
SQL> select distinct manager_id from employees;
||连接符使用以及 加减乘除以及括号的使用
SQL> select employee_id,first_name||'.'||last_name,salary(1+0.1)/100,manager_id
2 from employees;
+-做正负号使用
SQL> select -salary from employees;
<>,>,<,=,!=等比较操作符
SQL> select from employees where salary >13000;
SQL> select from employees where salary <13000;
SQL> select from employees where salary <>13000;
SQL> select from employees where salary =13000;
In
SQL> select -salary from employees where employee_id in (100,101,102);
SQL> select -salary from employees where employee_id in (select employee_id from employees);
not in
SQL> select -salary from employees where employee_id not in (100,101,102);
Any(比任意一个都)
select from employees where employee_id >any(100,101,102);
some 是 SQL-92 标准的 any 的等效物
select from employees where employee_id >any(100,101,102);
all(比所有的都)
select from employees where employee_id >all(100,101,102);
between and
select from employees where employee_id between 100 and 102;
not between and
select from employees where employee_id not between 100 and 102;
逻辑操作符
And 和 or
select from employees where employee_id > 100 and employee_id < 1000;
select from employees where employee_id > 100 or employee_id < 1000;
Order by
Desc
select from employees where employee_id between 100 and 102 order by employee_id desc;
Asc
select from employees where employee_id between 100 and 102 order by employee_id asc;
dual哑元表没有表需要查询的时候可以用它
select sysdate from dual;
select 12345 from dual;
编程语言
- 甘肃哪有关键词排名优化购买方式有哪些
- 甘肃SEO如何做网站优化
- 河南seo关键词优化怎么做电话营销
- 北京SEO优化如何做QQ群营销
- 来宾百度关键词排名:提升您网站曝光率的关键
- 卢龙关键词优化:提升您网站排名的策略与技巧
- 山东网站优化的注意事项有哪些
- 四川整站优化怎样提升在搜索引擎中的排名
- 疏附整站优化:提升网站性能与用户体验的全新
- 海南seo主要做什么工作售后服务要做到哪些
- 荣昌百度网站优化:提升您网站的搜索引擎排名
- 河北seo网站排名关键词优化如何做SEO
- 江西优化关键词排名推广售后保障一般有哪些
- 古浪SEO优化:提升你的网站可见性
- 西藏网站排名优化怎么把网站排名在百度首页
- 如何提升阳东百度快照排名:详尽指南