前端-第二天

来源：互联网发布：信知汉王畏恶其能翻译编辑：程序博客网时间：2024/06/04 01:06

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)

阅读全文

1 0