명

왜 몰랐을까....

 mysql에 이렇게 유용한 함수가 있었군요.
 
GROUP_CONCAT([DISTINCT] expr [,expr ...]
             [ORDER BY {unsigned_integer | col_name | expr}
                 [ASC | DESC] [,col_name ...]]
             [SEPARATOR str_val])
mysql> SELECT student_name,
    ->     GROUP_CONCAT(test_score)
    ->     FROM student
    ->     GROUP BY student_name;
Or:
mysql> SELECT student_name,
    ->     GROUP_CONCAT(DISTINCT test_score
    ->               ORDER BY test_score DESC SEPARATOR ' ')
    ->     FROM student
    ->     GROUP BY student_name;
왜 몰랐을까..에혀.

댓글 4개

요거 문자열로 한방에 뽑아올때 좋더군뇽..
아.. 이런게 있었군요..
오호.. 좋은 팁이네요.
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
11-10-25 조회 2,516
11-10-18 조회 4,068
11-10-18 조회 2,455
11-10-15 조회 3,659
11-10-10 조회 2,726
11-10-02 조회 2,624
11-09-28 조회 2,435
11-09-24 조회 2,526
11-09-22 조회 2,427
11-09-05 조회 2,907
11-08-31 조회 2,311
11-08-31 조회 2,618
11-08-31 조회 2,460
11-08-29 조회 2,998
11-08-28 조회 2,500
11-08-25 조회 2,558
11-08-17 조회 2,263
11-08-16 조회 2,507
11-08-11 조회 2,968
11-08-07 조회 2,675
11-08-03 조회 2,387
11-07-22 조회 2,131
11-07-12 조회 3,335
11-06-27 조회 2,111
11-06-01 조회 1,778
11-05-17 조회 2,583
11-05-01 조회 2,636
11-04-28 조회 2,932
11-04-28 조회 2,986
11-04-13 조회 2,646
11-03-27 조회 2,765
11-03-27 조회 2,645
11-03-14 조회 2,053
11-03-02 조회 2,381
11-03-02 조회 2,603
11-02-27 조회 3,032
11-02-23 조회 2,408
11-02-19 조회 2,548
11-02-14 조회 4,163
11-02-03 조회 2,949
11-01-24 조회 3,899
11-01-04 조회 2,435
10-12-08 조회 5,444
10-11-15 조회 2,458
10-11-14 조회 2,649
10-11-14 조회 3,660
10-10-29 조회 3,721
10-10-19 조회 2,742
10-10-07 조회 2,569
10-10-05 조회 4,485
10-09-18 조회 2,781
10-09-18 조회 2,526
10-09-17 조회 4,936
10-09-15 조회 2,862
10-09-15 조회 2,397
10-09-15 조회 2,887
10-09-15 조회 2,719
10-09-11 조회 4,048
10-09-11 조회 2,549
10-09-11 조회 2,597
10-09-07 조회 3,869
10-09-07 조회 3,406
10-08-29 조회 2,861
10-07-01 조회 3,106
10-06-30 조회 2,516
10-06-30 조회 2,700
10-06-30 조회 3,043
10-06-13 조회 2,086
10-04-15 조회 3,259
10-04-04 조회 3,483
10-02-23 조회 3,601
10-02-09 조회 3,180
10-01-25 조회 2,695
10-01-25 조회 2,793
09-12-27 조회 4,441
09-11-23 조회 3,656
09-11-20 조회 4,898
09-08-30 조회 3,090
09-08-30 조회 3,094
09-08-12 조회 3,064
09-07-22 조회 4,120
09-07-22 조회 4,773
09-07-15 조회 5,922
09-07-11 조회 3,003
09-06-17 조회 2,744
09-06-15 조회 3,031
09-05-29 조회 3,321
09-05-11 조회 5,951
09-05-08 조회 2,710
09-04-30 조회 3,824
09-04-17 조회 3,150
09-04-04 조회 3,335
09-03-05 조회 3,710
09-02-09 조회 3,690
09-02-03 조회 6,185
08-12-27 조회 3,245
08-12-20 조회 4,323
08-11-21 조회 5,284
08-11-14 조회 2,858
08-11-03 조회 3,326