复习
- 数据库的密码加密:
(1)单向加密:insert into users (username,password) values ('ms',MD5('123456'));
(2)双向加密:insert into users (username,password) values ('ms',ENCODE('123','456'));
SQL聚合查询
select user_id from user group by user_id;
SQL筛选查询
select * from user where user_id in (select user_id from user group by user_id having count(user_id)>1)order by user_id desc;
- SQL衔接查询:
这里写代码片