PLSQL中增删该查命令

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;