sql数据库操作基本语句

INSERT INTO users (username,password,nickname) VALUES ('张三','123','lisi')

INSERT INTO blogs (title,content,userid) VALUES ('张三5','555',99)

DESC ASC 正序倒叙 LIMIT 多少条 OFFSET 跳过多少条 分页

SELECT * FROM blogs ORDER BY id DESC LIMIT 2 OFFSET 2

UPDATE blogs SET content='我已经更新了' WHERE id=1
DELETE FROM users WHERE id=1
SELECT COUNT(id) AS `count` from blogs
SELECT * FROM blogs INNER JOIN users ON users.id = blogs.userid

连表查询 不一定需要 外键 但是一般都存在 严谨性

检索出blogs的全部内容 users表的部分内容 根据什么条件 FROM blogs INNER JOIN users ON users.id = blogs.userid

SELECT blogs.*,users.username,users.nickname FROM blogs INNER JOIN users ON users.id = blogs.userid WHERE users.username = '张三'