UPDATE Sheet1SET c1 = ‘1‘WHERE c like ‘%1%‘
UPDATE Sheet1SET c2 = ‘1‘WHERE c like ‘%2%‘
UPDATE Sheet1SET c3 = ‘3‘WHERE c like ‘%3%‘
如何将数据库中的一列转换成多列
原文:http://www.cnblogs.com/Eaglery/p/5044111.html