Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
179 views
in Technique[技术] by (71.8m points)

mysql多表查询问题

我有三个表

// article
id  title
4   test
// tag
id name
1   tag1
2   tag2
3   tag3
// 第三方关联表 article_tag
id  tagId  articleId
1   1      4
2   2      4
3   3      4

article和tag是多对多的关系。现在要查article,希望通过第三方表把tagIds也都查出来。最后生成

articleId articleTitle tagIds
4         test         1,2,3

这样的sql该怎么写?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Article::with('tags')->findAll()


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...