Node/Koa2[05]: 增删改查/查询总数、分页

# 切换表
use koa2_weibo_db;

select * from users;

select * from blogs;

# 倒序排列
select * from blogs order by id desc;

# 新增
# password 是关键字，需要用 `` 包起来
insert into users (username,`password`,nickname) values(`zhangsan`,`123`,`张三`);

# 查询
# 查询指定的列
select username,nickname from users;

# 条件查询
select username,nickname from users where username='zhangsan' and `password`='123'

# blogs 表数据插入
insert into blogs(title,content,userid) values('标题1','内容1',1);

# 更新数据
update blogs set content='内容1内容1' where id=1;

# 删除数据
delete from blogs where id=4;

# 查询数据的总数量
# as 取一个别名
# select count(*) as `count` from blogs;
select count(id) as `count` from blogs;

# 分页查询
# 查询第一页的两条
select * from blogs order by id desc limit 2;
# 查询第二页的两条
select * from blogs order by id desc limit 2 offset 2;