mysql 数据库 crud

show databases;

-- 关闭 safe-updates 模式
SET SQL_SAFE_UPDATES = 0; 

select * from users; 
select * from blogs;

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

-- 查询总数
select count(uid) as `count` from users;

-- 倒序查询第二页
select * from blogs order by id desc limit 2 offset 2;


-- 新增用户
insert into users(username, `password`, nickname) values('zhangsan', '123', '张三');
insert into users(username, `password`, nickname) values('lisi', '123', '李四');
insert into users(username, `password`, nickname) values('lisi2', '123', '李四2');
insert into blogs(title, content, uid) values('标题433', '内容433', 3);

-- 查询用户  用于登录验证
select username, nickname from users where username='zhangsan' and `password`='123';

-- 更新
update blogs set content='内容2内容2' where id=2;

-- 删除
delete from blogs where id=1;
delete from users where uid=3;

-- 连表查询 blogs inner join users 两个表联合 on users.uid = blogs.uid 在条件
select * from blogs inner join users on users.uid = blogs.uid;
select blogs.*, users.username,
 users.nickname 
 from blogs inner join users on users.uid = blogs.uid;
 
select blogs.*, users.username,
 users.nickname 
 from blogs inner join users on users.uid = blogs.uid where blogs.id = 1;