Profile
Achievement
ktrout's Recent SnippetsTagged mysql
- All /
« Prev 1 Next »
pivot data. input source query in the form :
+--------+-----------+-------------+-------------+
| name | pivot_fid | pivot_fname | pivot_value |
+--------+-----------+-------------+-------------+
| apple | 1 | is red...
0
71
posted 4 years ago by ktrout
one cross join for each ai in definition of decimal number as sum(ai*10^i)
0
76
posted 4 years ago by ktrout