擅长:python、mysql、java
<p>如果知道列表,可以使用<code>group by</code>计算:</p>
<pre><code>SELECT email,
sum(val1 = 'cast') as `cast`,
sum(val1 = 'core') as `core`,
sum(val1 = 'cam') as `cam`,
. . .
FROM table1
GROUP BY email;
</code></pre>
<p><code>. . .</code>用于填充剩余的值。你知道吗</p>