SQL语句：建表语句、插入语句、查询语句、增加列、删除列、查询语句like、修改语句

1、建表

create table student (
  id number(10,0) not null,
  uname varchar2(255 char),
  pword varchar2(255 char),
  primary key (id)
);

2、插入

insert into student values(1,'张三','qweerwe');
insert into student values(2,'李四','asdff');
insert into student values(4,'王五7','ry123');

insert into USERINFODZ(USERNAME,USERPWD,age) values('Z自己56','322',56);

3、查询

全部查询

select * from student;

条件查询

(select * from USERINFODZ where age>15)

4、增加列、删除列

alter table USERINFODZ add agee number(10,0)

alter table USERINFODZ drop column agee 

5、查询 like语句

select * from USERINFODZ where username LIKE  '%围%'

只有包含“围”

select * from USERINFODZ where username LIKE  '围%'

开头是“围”

select * from USERINFODZ where username LIKE  '%围'

结束是“围”

6、修改语句

update student set uname='萨拉赫' where uname = '内马尔'

 

 

 

 

 

 

附：

总数：select count * as totalcount from table1

oracle查询总数：select count(*) from student;
　　求和：select sum(field1) as sumvalue from table1
　　平均：select avg(field1) as avgvalue from table1
　　最大：select max(field1) as maxvalue from table1
　　最小：select min(field1) as minvalue from table1