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

ACCESS数据库介绍

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

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

简单的增删改查

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

--查询 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等，这里就不展开了