{"id":733,"date":"2021-10-12T15:34:59","date_gmt":"2021-10-12T06:34:59","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=733"},"modified":"2021-10-12T15:34:59","modified_gmt":"2021-10-12T06:34:59","slug":"mysql-rank-function","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2021\/10\/12\/mysql-rank-function\/","title":{"rendered":"mysql rank function"},"content":{"rendered":"

mysql rank function <\/span><\/p>\n

create table ds (id int(11), login int(11)) <\/span><\/p>\n

insert into ds (id, login) <\/span><\/p>\n

values (1,1), <\/span><\/p>\n

(2,1), <\/span><\/p>\n

(3,1), <\/span><\/p>\n

(4,2), <\/span><\/p>\n

(5,2), <\/span><\/p>\n

(6,6), <\/span><\/p>\n

(7,6), <\/span><\/p>\n

(8,1) <\/span><\/p>\n

select result.id,result.login,result.rank from ( <\/span><\/p>\n

SELECT id, <\/span><\/p>\n

login, <\/span><\/p>\n

IF(login=@last,@curRank:=@curRank,@curRank:=@_sequence) AS rank, <\/span><\/p>\n

@_sequence:=@_sequence+1, <\/span><\/p>\n

@last:=login <\/span><\/p>\n

FROM ds , (SELECT @curRank := 1, @_sequence:=1, @last:=0) r <\/span><\/p>\n

ORDER BY id asc) as result; <\/span><\/p>\n

#\uac00\uc0c1 \ud638\uc2a4\ud2b8 \uc5f0\uacb0 <\/span><\/p>\n

\/etc\/httpd\/conf.d\/vhost.conf \ud30c\uc77c \uc0dd\uc131 \ud6c4 \uc544\ub798\ub0b4\uc6a9 \uae30\uc785\ub9cc\ud558\uba74 \ub428. <\/span><\/p>\n

<VirtualHost *:80> <\/span><\/p>\n

DocumentRoot \/home\/onepage\/public_html <\/span><\/p>\n

ServerName onepage.dev <\/span><\/p>\n

ServerAlias www.onepage.dev <\/span><\/p>\n

<Directory “\/home\/onepage\/public_html”> <\/span><\/p>\n

Require all granted <\/span><\/p>\n

<\/Directory> <\/span><\/p>\n

<\/VirtualHost> <\/span><\/p>\n

<VirtualHost *:80> <\/span><\/p>\n

DocumentRoot \/home\/wpuser\/public_html\/cosmos <\/span><\/p>\n

ServerName cosmos.dev <\/span><\/p>\n

ServerAlias www.cosmos.dev <\/span><\/p>\n

<Directory “\/home\/onepage\/public_html”> <\/span><\/p>\n

Require all granted <\/span><\/p>\n

<\/Directory> <\/span><\/p>\n

<\/VirtualHost> <\/span><\/p>\n

#shutdown -h +10 <\/span><\/p>\n

#shutdown -r 21:00 <\/span><\/p>\n

#shutdown -r now \ubc14\ub85c \uc7ac\ubd80\ud305 <\/span><\/p>\n

#shutdown -c <\/span><\/p>\n

#shutdown -k now \ud604\uc7ac \uc811\uc18d\uc790\uc5d0\uac8c \uc885\ub8cc\uba54\uc2dc\uc9c0\ub9cc \ubcf4\ub0b4\uace0, \uc2e4\uc81c\ub85c\ub294 \uc885\ub8cc\ud558\uc9c0 \uc54a\uc74c. <\/span><\/p>\n

#shutdown -r now, reboot , init 6 : \uc7ac\ubd80\ud305 \uba85\ub839 <\/span><\/p>\n

\ub85c\uadf8\uc544\uc6c3 <\/span><\/p>\n

#logout , exit <\/span><\/p>\n

\ub9ac\ub205\uc2a4 \uac00\ub3d9\ud558\ub294 \ubc29\ubc95 <\/span><\/p>\n

\ub7f0\ub808\ubca8: 7\ub2e8\uacc4(init \uba85\ub839) <\/span><\/p>\n

#init 0 : \uc885\ub8cc <\/span><\/p>\n

#init 1 : \ub2e8\uc77c \uc0ac\uc6a9\uc790\ubaa8\ub4dc(\uc2dc\uc2a4\ud15c\ubcf5\uad6c) <\/span><\/p>\n

#init 2 : \ub2e4\uc911 \uc0ac\uc6a9\uc790\ubaa8\ub4dc <\/span><\/p>\n

#init 3 : \ud14d\uc2a4\ud2b8\ubaa8\ub4dc\uc758 \ub2e4\uc911\uc0ac\uc6a9\uc790\ubaa8\ub4dc <\/span><\/p>\n

#init 4 : \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c <\/span><\/p>\n

#init 5 : \uc708\ub3c4\uc6b0\ubaa8\ub4dc\uc758 \ub2e4\uc911\uc0ac\uc6a9\uc790\ubaa8\ub4dc <\/span><\/p>\n

#init 6 : \uc7ac\ubd80\ud305 \ubaa8\ub4dc <\/span><\/p>\n

tty <\/span><\/p>\n

Ctrl + alt + F2, F3, F4, F5, F6 <\/span><\/p>\n

\ubd80\ud305\uba54\uc2dc\uc9c0 <\/span><\/p>\n

\/var\/log\/messages <\/span><\/p>\n

#dmesg \uba85\ub839\uc73c\ub85c \ud655\uc778 <\/span><\/p>\n

#man [\ubd84\ub958\ubc88\ud638] <\uba85\ub839\uc5b4> <\/span><\/p>\n

[space] : \ub2e4\uc74c \ud398\uc774\uc9c0 <\/span><\/p>\n

[b] : \uc774\uc804 \ud398\uc774\uc9c0 <\/span><\/p>\n

\/\uac80\uc0c9\ubb38\uc790\uc5f4 [Enter] <\/span><\/p>\n

?\uac80\uc0c9\ubb38\uc790\uc5f4 [Enter] <\/span><\/p>\n

[n] : \ub2e4\uc74c \ub2e8\uc5b4\ub85c \uc774\ub3d9 <\/span><\/p>\n

[q] : \uc885\ub8cc <\/span><\/p>\n

#vi abc.txt <\/span><\/p>\n

vi\uc758 \uc138\uac00\uc9c0 \ubaa8\ub4dc : \uc785\ub825\/\uba85\ub839\/\uc2e4\ud589 <\/span><\/p>\n

\uc785\ub825\ubaa8\ub4dc : \uae00\uc790\uc785\ub825 <\/span><\/p>\n

\uba85\ub839\ubaa8\ub4dc : \ud30c\uc77c\ud3b8\uc9d1 <\/span><\/p>\n

\uc2e4\ud589\ubaa8\ub4dc : \ud30c\uc77c \uc800\uc7a5, \uc77d\uae30, \uc678\ubd80\uba85\ub839\uc2e4\ud589, \uc885\ub8cc \ub4f1 <\/span><\/p>\n

\ucee4\uc11c\uc758 \uc774\ub3d9 <\/span><\/p>\n

\ud55c\ubb38\uc790\uc529 \uc774\ub3d9 h : \uc67c, j : \uc704, K : \uc544\ub798, l : \uc624\ub978\ucabd <\/span><\/p>\n

\ub2e8\uc5b4\uc758 \uc774\ub3d9 <\/span><\/p>\n

w : \ub2e4\uc74c\ub2e8\uc5b4\uc758 \uccab\uae00\uc790\ub85c <\/span><\/p>\n

b : \uc774\uc804\ub2e8\uc5b4 \ucc98\uc74c <\/span><\/p>\n

e : \ub2e4\uc74c\ub2e8\uc5b4\uc758 \ub05d <\/span><\/p>\n

\ud589\ub2e8\uc704 \uc774\ub3d9 <\/span><\/p>\n

^ : \ub9e8\uc704\ucabd\uc758 \uccab\uae00\uc790 <\/span><\/p>\n

$ : \ub9c8\uc9c0\ub9c9\uae00\uc790\uc758 \ub05d <\/span><\/p>\n

G : \ud30c\uc77c\uc758 \ub9c8\uc9c0\ub9c9\ud589 <\/span><\/p>\n

nG : <\/span><\/p>\n

\uc785\ub825\ubaa8\ub4dc : a, i – esc, :w, :q :wq :q! <\/span><\/p>\n

\uba85\ub839\ubaa8\ub4dc -esc <\/span><\/p>\n

x: \ud55c\uae00\uc790 \uc9c0\uc6b0\uae30 dw : \ucee4\uc2a4 \uc624\ub978\ucabd \ub2e8\uc5b4 \uc0ad\uc81c db : \ucee4\uc11c\uc67c\ucabd\ub2e8\uc5b4 \uc0ad\uc81c <\/span><\/p>\n

dd : \ud55c\uc904\uc0ad\uc81c ndd: \uc5ec\ub7ec\uc904 \uc0ad\uc81c yy : \ud55c\uc904\ubcf5\uc0ac, nyy : \uc5ec\ub7ec\uc904 \ubcf5\uc0ac <\/span><\/p>\n

p : \ud604\uc7ac \ucee4\uc11c \uc544\ub798\ub85c \ubd99\uc5ec\ub123\uae30 np : n\ubc88 \ubd99\uc5ec\ub123\uae30 <\/span><\/p>\n

u : \ubcf5\uad6c\ud558\uae30 <\/span><\/p>\n

r+\ubb38\uc790 : \ud55c\uae00\uc790 \uce58\ud658 R : \uce58\ud658\ubaa8\ub4dc cw : \ud55c\ub2e8\uc5b4 \uce58\ud658\ud558\uae30 <\/span><\/p>\n

%s\uce58\ud658\ubb38\uc790 \uce58\ud658\ud560\ubb38\uc790 <\/span><\/p>\n

~ : \ub300\uc18c\ubb38\uc790 \uc804\ud658 <\/span><\/p>\n

\/\uac80\uc0c9\uc5b4 : \uc544\ub798\ubc29\ud5a5\uc73c\ub85c \ucc3e\uae30 ?\uac80\uc0c9\uc5b4 : \uc717\ubc29\ud5a5\uc73c\ub85c \ucc3e\uae30 n : \ub2e4\uc74c \ucc3e\uae30 <\/span><\/p>\n

\ud14d\uc2a4\ud2b8\ubaa8\ub4dc \ub9c8\uc6b4\ud2b8 <\/span><\/p>\n

mount <\uc7a5\uce58\uba85> <\ub9c8\uc6b4\ud2b8\ud3ec\uc778\ud2b8> <\/span><\/p>\n

mount \/dev\/cdrom \/media\/cdrom <\/span><\/p>\n

mount \/dev\/sdb1 \/media\/usb <\/span><\/p>\n

umount <\uc7a5\uce58\uba85> \ub610\ub294 \ub9c8\uc6b4\ud2b8\ud3ec\uc778\ud2b8 <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

mysql rank function create table ds (id int(11), login int(11)) insert into ds (id, login) values (1,1), (2,1), (3,1), (4,2), (5,2), (6,6), (7,6), (8,1) select result.id,result.login,result.rank from ( SELECT id, login, IF(login=@last,@curRank:=@curRank,@curRank:=@_sequence) AS rank, @_sequence:=@_sequence+1, @last:=login FROM ds , (SELECT @curRank := 1, @_sequence:=1, @last:=0) r ORDER BY id asc) as result; #\uac00\uc0c1 \ud638\uc2a4\ud2b8 \uc5f0\uacb0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-733","post","type-post","status-publish","format-standard","hentry","category-mariadb-mysql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=733"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/733\/revisions"}],"predecessor-version":[{"id":734,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/733\/revisions\/734"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}