作者ginzu (茹)
看板Database
标题[SQL ] 改如何下指令显示栏位的值
时间Thu Nov 27 21:57:26 2008
TABLE内容如下:
该如何下SQL 指令显示type栏位的值
(主要是想知道哪些email存在两种或是三种类别)
email type
[email protected] E
[email protected] P
[email protected] P
[email protected] H
[email protected] H
[email protected] E
[email protected] P
[email protected] H
[email protected] E
[email protected] E
变成
email type
[email protected] E,P
[email protected] P
[email protected] P,H,E
[email protected] H
[email protected] H,E
[email protected] E
[email protected] P
谢谢!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.169.135.201
1F：推 bobju:type要独立出来, 跟email所属的表做切割. 两者之间再建一个 11/28 07:33
2F：推 bobju:..以上不算. 我想应该是为'查询',而非要重建资料表. 11/28 07:48