学习目标:
sql
学习内容:
全列查询
Select*from score;
指定列查询
select name,score from score;
为查询结果指定别名
select id,name as ‘hhh’ from score;
修改update score set english=40 where name=‘张三’;
删除delete from score where name=‘王五’;
Like模糊查询
通配符%百分号匹配零个,一个或多个字符
select name from students where name like ‘w%’;匹配以w开始的字符串
select name from students where name like ‘%a%’;匹配包含a的字符串
select name from students where name like ‘%i’;匹配以i结尾的字符串
通配符_下划线符号匹配单个字符。
select name from score where name like ‘wangw_’;以wangw_开始,后面只有一个字符
select name from students where name like ‘_ang’;以ang结尾,前面只有一个字符
混用
select name from students where name like ‘%a_’;
select name from students where name like ‘_a%’;
若不存在,则返回
学习时间:
1月-3月,每天一小时左右
学习产出:
一周一发