MySQL ö×éé» ° óè ¡Ö ö öö×éöð ° 'Õ Ä ä³ Ð©×Ö ~~~~~~*************************************************************

MySQL ö×éè» ° óè ¡Ö ö öö×éöð ° '~~~~******************************************* too many other users

MySQL ö×éè» ° óè ¡Ö ö öö×éöð ° '~~~~******************************************* too many other users

½ R±í

CREATE TABLE `t` (  `a` int(11) DEFAULT NULL,  `b` int(11) DEFAULT NULL,  `c` int(11) DEFAULT NULL,  `itime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. *********************

INSERT INTO  t(`a`, `b`, `c`, `itime`) VALUES ('1', '1', '1', '2014-12-04 19:07:01');INSERT INTO  t(`a`, `b`, `c`, `itime`) VALUES ('1', '1', '2', '2014-12-04 19:07:02');INSERT INTO t (`a`, `b`, `c`, `itime`) VALUES ('1', '1', '3', '2014-12-04 19:07:03');INSERT INTO t (`a`, `b`, `c`, `itime`) VALUES ('1', '1', '4', '2014-12-04 19:07:04');INSERT INTO  t(`a`, `b`, `c`, `itime`) VALUES ('1', '2', '1', '2014-12-04 19:07:01');INSERT INTO t (`a`, `b`, `c`, `itime`) VALUES ('1', '2', '2', '2014-12-04 19:07:02');INSERT INTO  t(`a`, `b`, `c`, `itime`) VALUES ('1', '2', '3', '2014-12-04 19:07:03');INSERT INTO t (`a`, `b`, `c`, `itime`) VALUES ('1', '2', '4', '2014-12-04 19:07:04');INSERT INTO  t(`a`, `b`, `c`, `itime`) VALUES ('1', '2', '5', '2014-12-04 19:07:05');INSERT INTO t (`a`, `b`, `c`, `itime`) VALUES ('1', '2', '6', '2014-12-04 19:07:06');

° 'Minimum latency, b. ö×é £;² Ç 正° ° '{õ itime ×ö¶ {{{{%^^^^%%%%%%%%%%******** top3

SELECTt.a,  t.b,substring_index(group_concat(IFNULL(t.c,0)ORDER BYt.itime DESC),",",3) c,substring_index(group_concat(t.itimeORDER BYt.itime DESC),",",3) timeFROMt tGROUP BYt.a ,t.b;

Á á¹ ¼ ~~~~â £°

×¢ Ò â £°

Comment» Comment comment '{· }% *************************************************************** Ó órāzömámámímámámámámámámámámémémén ¯ ° ó Ó 'Ó £? · öé É tZ networks · networks "http://www.bkjia.com/kf/ware/vc/" target = "_ blank" class = "keylink"> networks/networks + tv6hoklGTlVMTMXQts + queues/b7dt8W9 + queues + CjxwPjxpbWcgc3JjPQ = "" alt = "\">

PS £° çáç¹ ²» çíò ²» µã {€£;%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%» â é Ô úmysql öð ¹ Ó È çç' Ë ¸ 'ó ózäsql £?

 ç û äã Ó Ð ü ° ã µäð '? £;}» copyright»