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
963
posted 9 years ago by ktrout
one cross join for each ai in definition of decimal number as sum(ai*10^i)
0
948
posted 9 years ago by ktrout