Mysql的学习

记录一下Mysql的学习.

---

基础和提高篇,我认为看这里就够了.
基础,写的比较详细了…

---

需要先关联俩表再和另外一个关联俩表的联合查询…
我这样写

select * from 
(select comments.id faid,articleId,userId,to_commentId,content,comments.createtime,user.id,username,headImgUrl from comments,user where comments.articleId=47 and comments.userId = user.id) 
as t1 
left  join 
(select comments.id paid,articleId,userId,to_commentId,content,comments.createtime,user.id,username,headImgUrl from comments,user where comments.articleId=47 and comments.userId = user.id) 
as t2 
on t1.to_commentId = t2.paid;

参考是从这里学的.

---

Mysql8.0导出sql文件.
mysqldump -u (用户名) -p (数据名)>(导出的地方.sql)

---