mysql数据操作
创建表
create table 表名 (列名1 类型 (长度),列名2 类型(长度));
create table student (s_id varchar(10),s_name varchar(10));
增加
insert into 表名 values(值1,值2)
insert into student values('1','小明');
删除 delete from table where <条件>
delete from student where s_name='小明';
更改 update 表名 set 列名=‘xxx’ where= <条件>
update sudent set s_name='a' where s_id='1'
最主要是select,我还未工作,老师说,工作公司只给select权限
查询表 select
select *from table (where 列名=? )
select * from student
排序:升序
select s_id,s_age from student order by s_age
排序:降序
select s_id,s_age from student order by s_age desc
分组
select * from student group by s_age,s_name,s_id
select * from table group
最大值
最小值
模糊查询
having
平均值
SELECT AVG(column_name) FROM table_name
子查询
SELECT s_name ,avg(s_age) from (SELECT * from student where s_age < 18)a
count