|
如何写
multiple rows with same value in one column to multiple columns with 1 row
example
id subject status
1 math pass
1 chinese pass
2 math pass
2 chinese pass
change it to the structure below
id math chinese
1 pass pass
2 pass pass
[ 本帖最后由 stephanie83 于 28-8-2006 05:38 PM 编辑 ] |
|
|
|
|
|
|
|
发表于 28-8-2006 07:28 PM
|
显示全部楼层
原帖由 stephanie83 于 28-8-2006 05:36 PM 发表
如何写
multiple rows with same value in one column to multiple columns with 1 row
example
id subject status
1 math pass
1 chinese pass
2 math pass
2 chinese pass
change it to the structure below
id math chinese
1 pass pass
2 pass pass
你是要重新设计更好的table(s) structure,
还是alter 现有的table structure, 以把现有data record update去alter后的table structure? |
|
|
|
|
|
|
|
楼主 |
发表于 29-8-2006 09:38 AM
|
显示全部楼层
原帖由 亡者之疯 于 28-8-2006 07:28 PM 发表
你是要重新设计更好的table(s) structure,
还是alter 现有的table structure, 以把现有data record update去alter后的table structure?
我是要把之前已有的table structure
换去alter 后的table structure |
|
|
|
|
|
|
| |
本周最热论坛帖子
|