2.kanban介绍 就是讲团队任务的分工合作
3.given,when,then TDD测试驱动开发
4.注册页面的完成(对昨天讲解的问题回顾)
5.左边链接,右边页面显示
数据库的学习
1.数据库的操作:创建、删除表
2.对表记录进行操作 ****like语句不配合下划线或者百分号就相当于等于'%a' 查出以a结尾的记录'_a' 查出第二个字符为a的记录
****下划线表示一个字符,百分号表示多个字符查%要在%前面加一个\,例:'%\%%'查询\%的记录
****ESCAPE 自定义一个转意字符
****排序 有两个条件时,先满足第一个条件
3.下午实例语句
insert into user values(5,'ad\%sd',1,'sdsfafd')
select * from user
select user_id from user
select user_id,user_name from user
select user_name as 用户名 , user_password as 密码 from user
select DISTINCT user_password from user
select user_id from user where user_id !=1
select user_id from user where user_id <>1
select user_id from user where user_id >2
select user_id from user where user_id <3
select user_id from user where user_id <=2
select user_id from user where user_id >=1
select * from user where user_password like '%s%'
select user_password from user
select * from user where user_password not like '%s%'
select * from user where user_id = 1 or user_id = 3 or user_id = 4
select * from user where user_id in (1,3,4)
select * from user where user_id not in( 2,4)
select * from user where user_id not in( 2,4) ORDER BY user_id desc
select * from user where user_id not in( 2,4) ORDER BY user_id asc
select * from user where user_id not in( 2,4) ORDER BY user_id desc , user_sex asc
select * from user where user_password like '%d%%' escape 'd'