前端-第二天

1.了解Trello ,看板

2.完成一个注册页面

3.Frameset的使用，可参考

http://blog.sina.com.cn/s/blog_604527460100niqj.html   

4.了解Database的种类

5.sql语句：

DELETE FROM `user` WHERE userId = 4 


INSERT INTO `user` (username, PASSWORD) VALUES("dd", 999) UPDATE USER


SET username = "gao" WHERE username LIKE '%康%'


SELECT * FROM `user`


SELECT username as 用户名,PASSWORD as 密码 FROM `user` 


SELECT DISTINCT username FROM `user`


SELECT username FROM user WHERE userId <>2


SELECT username FROM user WHERE userId >2


SELECT userId FROM user where username LIKE '%a'


SELECT userId FROM user where username LIKE '%a%'


SELECT userId FROM user where username LIKE '_a%'


SELECT userId FROM user where username LIKE '_a'


SELECT userId FROM user where username LIKE '____%'


SELECT userId FROM user where username LIKE '%\%%'


SELECT * FROM user WHERE username LIKE '%\?%%' ESCAPE '?'


SELECT * FROM user WHERE username  not LIKE '%\?%%' ESCAPE '?'


SELECT * FROM `user` WHERE userId =1 or userId =5


SELECT * FROM `user` WHERE userId in (1,5) 


select * FROM `user` ORDER BY flag ASC


select * FROM `user` ORDER BY flag DESC

其中特别注意的是like的使用：

like 不加上“%”或者“_”就等于“等于”


like '%a' 查询以a结尾的


LIKE '_a%'查询第二个字符是a的  （以此类推）


LIKE '_% 查询字符长度>=1     （以此类推）


LIKE '%\%%' 查询有“%”的  （使用“/”转译字符）


LIKE '%\?%%' ESCAPE '?'  自定义转译字符"?"


not LIKE  查询其他的


SELECT * FROM `user` WHERE userId =1 or userId =5 “等于” SELECT * FROM 


`user` WHERE userId in (1,5)