如何转换结果集行成columnn
答
如下尝试:
SELECT
if(user_id=57, 57, '') as user57,
if(user_id=57, 83, '') as user83,
if(user_id=57, 71, '') as user71,
if(user_id=57, 40, '') as user40,
if(user_id=57, 96, '') as user96,
if(user_id=57, 58, '') as user58,
if(user_id=57, 99, '') as user99,
if(user_id=57, 27, '') as user27,
FORM tablename
假设你是行修复。
答
这是一个数据透视表。
这里是一个教程的链接了解如何在MySQL转动:http://www.artfulsoftware.com/infotree/queries.php#78
上有SO关于这个问题有很多问题/答案为好。
@ MURTUZA007:这8行已修复? – 2012-04-04 16:02:11
是的,这永远不会改变 – unknown007 2012-04-04 16:19:15