第3章 数据库操作-ACCESS数据库介绍、SQL语句（增、删、改、查）、其它SQL语句

ACCESS数据库介绍

好low，学完基础课程课程水平好浅，数据库的课程竟然用的access，感觉教的钱不值得。

 SQL语句（增、删、改、查）

简单的增删改查

--查询
select * from user;
select * from user where name='小红';
select * from user order by age desc;  --desc降序、asc升序
select * from user where name like  '小%' order by age desc;
select top 10 * from user;  --不支持的sql语句
select * from user where age in(20,22,28);
select * from user where age between 20 and 25;
--更新
update user set name='小王' where id =1;
update user set name='小王',age=22,shengao=199 where id =1;
--删除
delete from user where id =1;
delete from user;
--添加
insert into user(name,age,shengao) values ("小帅","29","188")

其它SQL语句

alter、create、聚合函数、drop等，这里就不展开了