PLSQL中增删该查命令

爱被打了一巴掌 2022-04-24 12:46 282阅读 0赞

1 insert  
语法: insert into 表名称 values(值1,值2);  
insert into person values('github','c++','java','mysql');  
insert into  persion(name,password) values('张三',123);

2 delete  
语法: delete from 表名称 where 列名称=值  
删除某行  
delete from persion where lastname ='zhangsan';  
删除所有行:  
delete from table\_name  
或者  
delete \* from table\_name;

3 updata  
语法:updata 表名称 set 列名称=新值 where 列名称=某值  
更新某一行中一个列  
updata persion set firstname ='lisi' where lastname='zhangsan';  
更新某一行的诺干列  
修改地址,并添加新的城市名称  
update persion set address ='zhenghzou',city='nanjing' where lastname='zhangsan';  
4 select  
语法:select 列名称 from 表名称  
select \* from 表名称  
获取列名称为"lastname" 和"firstname"的列内容  
select lastname ,firstname from  persion;  
获取表中所有的列名称  
select \* from persion  
指定条件查询  
select \* form persion where id=2;  
select连接字符串并起别名  
select firstname+''+lastname as 名字 from persion  
查询表中所有ID不为1的记录  
select \* from persion where not id=1;  
带and多条件查询,没有符合条件的记录,返回为空  
带or的多条件查询  
select \* from persion where id or firstname='a1';  
select \* from persion where id=1 and firstname='a1';  
5 order by 排序  
select \* from persion order by id desc;  
select \* from persion order by id asc;  
6 模糊查询  
% 零或多个字符  
select \* from persion where firstnam like 'a%';  
\_ 一个字符  
select \* from persion where firstname like 'a\_';  
\[\] 指定范围内的任意单个字符  
select \* from persion where firstname like'a\[a-e\]';  
select \* from persion  where firstname like 'a\[bcd\]';  
\[^\]不属于指定范围内的任单个字符  
select \* from persion where firstname like'a\[^bcd\]';  
select \* from persioin  where firstname likt '\[bcd\]%';  
7 between and   
select \* from  between 1 and 2;