|
  |
15년 전 |
예제)
SELECT name,
SUM(CASE date WHEN $rows[0] THEN qty ELSE 0 END) AS '$rows[0]',
SUM(CASE date WHEN 2002 THEN qty ELSE 0 END) AS '2002',
SUM(CASE date WHEN 2003 THEN qty ELSE 0 END) AS '2003',
SUM(CASE date WHEN 2004 THEN qty ELSE 0 END) AS '2004'
FROM graph GROUP BY name;
=>응용
<?
mysql_connect("localhost","root","aporia");
mysql_select_db("aporia");
$QUERY="select distinct date from graph";
$result=mysql_query($QUERY);
while($rows=mysql_fetch_row($result)){
$sql[]="SUM(CASE date WHEN ".$rows[0]." THEN qty ELSE 0 END) AS '".$rows[0]."'";
}
$isql=implode(",",$sql);
$isql="select name, ".$isql." FROM graph GROUP BY name";
echo $isql;
?> |
|
 추천 : 393 |
추천
목록
|
|
