行转列技巧实例

INSERT INTO goods_temp
SELECT
	a.goods_id,
  a.bn as 商品编码,
	a.`name` as 商品名称,
	a.common_name as 通用名,
	i.manufacturer as 生产厂家,
	a.cfProperty 处方分类,
	a.valid_period as 有效期,
	a.approval_number as 批准文号,
	a.storage_methods as  贮藏,
  MAX(CASE p.`name` when '适应症' THEN p.content else '' end) as 适应症,
  MAX(CASE p.`name` when '不良反应' THEN p.content else '' end) as 不良反应,
  MAX(CASE p.`name` when '禁忌' THEN p.content else '' end) as 禁忌,
  MAX(CASE p.`name` when '注意事项' THEN p.content else '' end) as 注意事项,
  MAX(CASE p.`name` when '药物相互作用' THEN p.content else '' end) as 药物相互作用,
  MAX(CASE p.`name` when '性状' THEN p.content else '' end) as 性状,
	MAX(CASE p.`name` when '剂型' THEN p.content else '' end) as 剂型,
	MAX(CASE p.`name` when '规格' THEN p.content else '' end) as 规格,
	MAX(CASE p.`name` when '用法用量' THEN p.content else '' end) as 用法用量,
	'' as 税务编码,
	'' as 生产厂家简称,
	'' as 英文名,
	i.unit as 包装单位,
	a.goods_barcode as 小包装条码,
	'' as 中包装条码,
	'' as 批准文号效期,
	'' as 大包装条码
FROM
	o2o_goods a
LEFT JOIN o2o_goods_info i ON a.info_id = i.info_id
LEFT JOIN o2o_goods_params p on a.goods_id=p.goods_id
WHERE
	a.approval_number LIKE '国药准字%'
OR a.approval_number LIKE 'Z%'
OR (
	a.approval_number LIKE 'S%'
	AND length(a.approval_number) = 9
	AND a.approval_number NOT LIKE '%/%'
)
OR (
	a.approval_number LIKE 'H%'
	AND a.approval_number NOT LIKE '%-%'
) GROUP BY a.goods_id;

复制链接，在浏览器打开
tomcat源码解析
https://study.163.com/course/introduction/1209535854.htm

Springmvc源码解析
https://study.163.com/course/introduction/1209536851.htm