mysql workbench 对其中一个表格进行了调整,alter table mm;
SELECT nsrmc,
SUM(CASE WHEN hmc ='A' THEN bnljs ELSE 0 END) as 'zysr',
SUM( CASE WHEN hmc = 'B' THEN bnljs ELSE 0 END) as 'zycb' ,
SUM( CASE WHEN hmc = 'C' THEN bnljs ELSE 0 END) as 'zysj',
FROM mm GROUP BY nsrmc; 现在小白的问题来了,如何把调整后的表格保存成一张新表?很白痴,我不会,逃走了,谢谢各位。
SELECT nsrmc,
SUM(CASE WHEN hmc ='A' THEN bnljs ELSE 0 END) as 'zysr',
SUM( CASE WHEN hmc = 'B' THEN bnljs ELSE 0 END) as 'zycb' ,
SUM( CASE WHEN hmc = 'C' THEN bnljs ELSE 0 END) as 'zysj',
FROM mm GROUP BY nsrmc; 现在小白的问题来了,如何把调整后的表格保存成一张新表?很白痴,我不会,逃走了,谢谢各位。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货