리자

MySQL 성능 최적화 중 INNER JOIN ... USING 메모

· 2011-08-31 (수) 10:21:42 · 3279
create table daily_hit_counter ( day date not null, slot tinyint unsigned not null, cnt int unsigned not null, primary key (day, slot) );


update daily_hit_counter as c inner join ( select day, sum(cnt) as cnt , min(slot) as mslot from daily_hit_counter group by day) as x using(day) set c.cnt = if(c.slot = x.mslot, x.cnt, 0), c.slot = if (c.slot = x.mslot, 0, c.slot);<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
12-08-29 조회 4,245
12-08-07 조회 3,887
12-08-03 조회 3,702
12-07-31 조회 3,799
12-07-30 조회 3,745
12-07-16 조회 3,951
12-07-15 조회 3,787
12-07-07 조회 3,647
12-07-06 조회 3,842
12-07-03 조회 3,795
12-06-29 조회 3,432
12-06-22 조회 3,794
12-06-17 조회 4,055
12-05-21 조회 3,981
12-05-02 조회 3,484
12-05-02 조회 4,276
12-05-02 조회 3,406
12-04-30 조회 3,610
12-04-30 조회 3,276
12-03-17 조회 4,156
12-03-10 조회 3,476
12-03-08 조회 4,022
12-03-03 조회 3,715
12-02-27 조회 5,137
12-02-17 조회 4,440
12-02-16 조회 4,717
12-02-03 조회 3,374
12-01-31 조회 3,293
12-01-24 조회 3,286
12-01-17 조회 3,990
12-01-05 조회 3,534
11-12-30 조회 3,255
11-12-23 조회 4,839
11-12-08 조회 3,596
11-12-07 조회 4,545
11-11-27 조회 3,983
11-11-25 조회 4,307
11-11-23 조회 3,740
11-11-22 조회 3,597
11-11-09 조회 3,312
11-10-23 조회 3,242
11-10-19 조회 3,221
11-10-08 조회 2,895
11-10-04 조회 2,899
11-10-04 조회 5,350
11-09-01 조회 4,432
11-08-13 조회 2,619
11-08-06 조회 3,291
11-07-11 조회 3,678
11-06-27 조회 3,037
11-06-21 조회 2,698
11-06-13 조회 2,508
11-06-07 조회 2,526
11-05-26 조회 2,463
11-04-20 조회 2,807
11-03-21 조회 2,901
11-03-18 조회 2,600
11-03-11 조회 2,604
11-02-07 조회 2,443
11-01-18 조회 2,758
11-01-12 조회 2,481
11-01-06 조회 2,560
10-12-10 조회 2,834
10-12-09 조회 2,683
10-12-08 조회 5,119
10-11-29 조회 2,935
10-11-28 조회 2,845
10-11-28 조회 2,679
10-11-19 조회 2,875
10-11-04 조회 2,755
10-10-21 조회 2,474
10-10-19 조회 3,451
10-10-12 조회 2,757
10-10-07 조회 2,602
10-09-30 조회 3,560
10-09-17 조회 3,972
10-09-17 조회 3,914
10-05-31 조회 3,645
09-12-31 조회 3,765
09-07-23 조회 5,091
08-09-16 조회 3,290
08-09-06 조회 3,022
08-09-04 조회 3,453
08-08-16 조회 4,480
08-08-15 조회 3,345
08-08-14 조회 4,559
08-08-12 조회 4,026
08-07-23 조회 2,833
08-07-10 조회 3,791
08-07-04 조회 3,012
08-06-27 조회 7,648
08-06-19 조회 4,964
08-05-27 조회 5,575
08-05-25 조회 5,411
08-05-23 조회 3,488
08-05-23 조회 4,655
08-05-21 조회 5,001
08-05-20 조회 4,114
08-05-20 조회 3,336
08-04-18 조회 4,413