mysql 行列转换 pivot,Mysql Pivot表：行列转换

Table 1:

DocId,DocumentName,ModuleId

Table 2:

Id,DocumentTypeId,ModuleId,ModuleDetailId.

Want to create a pivottable with Document Name as Column headers

and whenTable2.DocumentTypeID = DocId then put 'Y' as Value

otherwise 'N'

Please suggest asolution.

解决方案There are a lot of tutorials available that tell you how to accomplish it (like this[^] one). However, it only works when you know the number of distinct values on your DocumentName field. If yes, you can go check that tutorial. If not, pivoting the table would not be a good idea in my opinion. If the values on your DocumentName field are dynamic, I suggest just joining the tables on your query and add an additional field where you can put the 'N' and 'Y' values.