记录一下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)