天下无坑

天下无坑


多列多行转存单列单行json

<h3>一对多,将多表多列多行转成一表单列单行的json字符串</h3> <pre><code class="language-sql">SELECT o.id,m.id mid, CONCAT( '[', GROUP_CONCAT( '{', CONCAT('"color":"',m.color,'"'),',', CONCAT('"price_jd":"',m.price_jd,'"'),',', CONCAT('"price_86":"',m.price_86,'"'), '}' ), ']' ) as price FROM `prices` m right join products o on o.id=m.pid group by(m.pid) </code></pre>

页面列表

ITEM_HTML