第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等,这里就不展开了