{"id":1425,"date":"2019-09-14T21:43:24","date_gmt":"2019-09-14T12:43:24","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1425"},"modified":"2019-09-24T00:00:41","modified_gmt":"2019-09-23T15:00:41","slug":"sql-mysql-data-sample","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/mysql\/sql-mysql-data-sample\/","title":{"rendered":"[SQL] mysql data sample"},"content":{"rendered":"

\ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778, \ub9c8\ud2b8 \uac1c\ubc1c \uc5c5\ubb34\ub97c \ub9e1\uac8c \ub418\uba74\uc11c SQL \uc5ed\ub7c9\uc5d0 \ub300\ud55c \ud544\uc694\uc131\uc744 \ub9ce\uc774 \ub290\ub080\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c0\ub2c8\uc5b4\ub85c \uc77c\ud588\ub358 \uc774\uc804\uae4c\uc9c0\uc758 \uacbd\ub825\uc5d0\uc11c\ub294 DB \uc778\uc2a4\ud134\uc2a4 \ub808\ubca8\uc5d0\uc11c \uc2dc\uc2a4\ud15c \uad6c\ucd95\uc5d0 \ub208\ub192\uc774\uac00 \ub9de\ucdb0\uc838\uc788\uc5c8\ub2e4.
\nDB \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uc77c\uc744 \ub9ce\uc774 \ud574\ubcf4\uae30\ub294 \ud588\uc9c0\ub9cc \uc778\uc2a4\ud134\uc2a4 \ub9ac\ud3ec\ud2b8\uc758 \uba87\uac00\uc9c0 \uc9c0\ud45c\ub97c \ubcf4\uace0 \uc801\uc808\ud55c \uc124\uc815\uc744 \ud558\ub294 \uc77c\ub4e4 \uc704\uc8fc\uc600\uace0, SQL\uc740 \uc774\ubbf8 \uc9dc\uc5ec\uc9c4 \ucffc\ub9ac\ub97c \uac04\ub2e8\ud788 \ubcc0\ud615\ud574\ubcf4\ub294 \uc815\ub3c4\uc774\uac70\ub098 \uc2dc\uc2a4\ud15c \uce74\ud0c8\ub85c\uadf8\ub97c \ub4a4\uc9c0\ub294 \uc815\ub3c4\uc758 \ucffc\ub9ac \ubc16\uc5d0 \ud574\ubcf4\uc9c0 \ubabb\ud55c \uac83 \uac19\ub2e4.<\/p>\n

\ud68c\uc0ac\uc5d0 \uc774\ubbf8 \uc798 \ub9cc\ub4e4\uc5b4\uc838\uc788\ub294 \ub9c8\ud2b8 SQL\ub4e4\uc744 \ud1b5\ud574 \uacf5\ubd80\ud574\uc57c\uaca0\uc9c0\ub9cc \ud639\uc2dc\ub098 \uc774\ud574\uac00 \uc798 \uc548\ub418\ub294 \ubd80\ubd84\uc774 \uc788\uc744\ub54c\ub294 \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \ud14c\uc2a4\ud2b8\ud574\ubcfc \uc218 \uc788\ub294 \ub370\uc774\ud130\uac00 \uc788\uc5c8\uc73c\uba74 \ud588\ub294\ub370 \ub9c8\uce68 mysql \uc5d0\uc11c \uacf5\uc2dd\uc801(https:\/\/dev.mysql.com\/doc\/employee\/en\/<\/a>)\uc73c\ub85c \uc0d8\ud50c \ub370\uc774\ud130\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/p>\n

\uae43\ud5d9(https:\/\/github.com\/datacharmer\/test_db<\/a>)\uc5d0\uc11c \ub0b4\ub824\ubc1b\uc744 \uc218 \uc788\uace0 \uc544\ub798\uc640 \uac19\uc774 \uac04\ub2e8\ud558\uac8c import \ud560 \uc218 \uc788\ub2e4.<\/p>\n

git clone https:\/\/github.com\/datacharmer\/test_db.git\ncd test_db\nmysql -u root -p < employees.sql\nmysql -u root -p < employees_partitioned.sql #\ud30c\ud2f0\uc158 \ud14c\uc774\ube14\ub85c \uc0dd\uc131\ud558\ub294 \uacbd\uc6b0<\/code><\/pre>\n
\n\uc131\uacf5\uc801\uc73c\ub85c \ub85c\ub529\uc774 \ub05d\ub098\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131\ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ub370\uc774\ud130\ub3c4 \uc801\ub2f9\ud788 \ub4e4\uc5b4\uc788\ub2e4.<\/p>\n
--mysql -uroot -p -D employees\n\nmysql> show tables;\n+----------------------+\n| Tables_in_employees  |\n+----------------------+\n| current_dept_emp     |\n| departments          |\n| dept_emp             |\n| dept_emp_latest_date |\n| dept_manager         |\n| employees            |\n| salaries             |\n| titles               |\n+----------------------+\n8 rows in set (0.00 sec)\n\nmysql> desc employees;\n+------------+---------------+------+-----+---------+-------+\n| Field      | Type          | Null | Key | Default | Extra |\n+------------+---------------+------+-----+---------+-------+\n| emp_no     | int(11)       | NO   | PRI | NULL    |       |\n| birth_date | date          | NO   |     | NULL    |       |\n| first_name | varchar(14)   | NO   |     | NULL    |       |\n| last_name  | varchar(16)   | NO   |     | NULL    |       |\n| gender     | enum('M','F') | NO   |     | NULL    |       |\n| hire_date  | date          | NO   |     | NULL    |       |\n+------------+---------------+------+-----+---------+-------+\n6 rows in set (0.00 sec)\n\nmysql> select count(*) from employees;\n+----------+\n| count(*) |\n+----------+\n|   300024 |\n+----------+\n1 row in set (0.09 sec)<\/code><\/pre>\n
\n\uc9c0\ub09c \uc77c\uc774\uc9c0\ub9cc \ud2f0\ubca0\ub85c\ub3c4 \uc774\ub7f0 \uc0d8\ud50c\ub370\uc774\ud130\uc640 \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0\uac00 \uc788\uc5c8\uc73c\uba74 \ucc38 \uc88b\uc558\uc744 \uac83 \uac19\uc740\ub370 \ub2e4\uc74c\uc5d0 \ud2f0\ubca0\ub85c \ub370\uc774\ud130 \uc0d8\ud50c \uae43\ud5d9 \ub808\ud30c\uc9c0\ud1a0\ub9ac\ub97c \ud55c\ubc88 \ub9cc\ub4e4\uc5b4\ubd10\uc57c\uaca0\ub2e4.<\/del><\/p>\n
\uae30\uc874\uc5d0 \ub9cc\ub4e4\uc5b4\uc838 \uc788\ub294 \ub9c8\ud2b8\uc5d0 \uc774\uc6a9\ub41c \ubb38\ubc95\uc744 \uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uad6c\ud604\ud574\ubcf4\ub294 \uac83 \uc704\uc8fc\ub85c \uacf5\ubd80\ud574\ubcfc \uc608\uc815\uc774\uba70 \ube45\ub370\uc774\ud130 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \ucffc\ub9ac\ud558\ub294 \uc77c\uc774 \ub300\ubd80\ubd84\uc774\uae30 \ub54c\ubb38\uc5d0 ANSI SQL\ub85c \ucffc\ub9ac\ub97c \uc791\uc131\ud558\ub294 \ubc29\ubc95\uc5d0\ub3c4 \uc775\uc219\ud574\uc838\uc57c\ud560 \uac83 \uac19\ub2e4.<\/p>\n
\uc2e4\uc81c \uc640\ub2ff\ub294 \ub0b4\uc6a9\uc744 \ubf51\uc544\ubcf4\uace0\uc2f6\uc744 \ub54c\uc5d0\ub294 nextcloud \uba54\ud0c0 \ud14c\uc774\ube14\ub85c \uc5ec\ub7ec \uc694\uc57d \uc815\ubcf4\ub97c \ubf51\uc544\ubcf4\ub294 \uac83\ub3c4 \uc7ac\ubbf8\uc788\uc744 \uac83 \uac19\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ub370\uc774\ud130 \ud30c\uc774\ud504\ub77c\uc778, \ub9c8\ud2b8 \uac1c\ubc1c \uc5c5\ubb34\ub97c \ub9e1\uac8c \ub418\uba74\uc11c SQL \uc5ed\ub7c9\uc5d0 \ub300\ud55c \ud544\uc694\uc131\uc744 \ub9ce\uc774 \ub290\ub080\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5d4\uc9c0\ub2c8\uc5b4\ub85c \uc77c\ud588\ub358 \uc774\uc804\uae4c\uc9c0\uc758 \uacbd\ub825\uc5d0\uc11c\ub294 DB \uc778\uc2a4\ud134\uc2a4 \ub808\ubca8\uc5d0\uc11c \uc2dc\uc2a4\ud15c \uad6c\ucd95\uc5d0 \ub208\ub192\uc774\uac00 \ub9de\ucdb0\uc838\uc788\uc5c8\ub2e4. DB \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uc77c\uc744 \ub9ce\uc774 \ud574\ubcf4\uae30\ub294 \ud588\uc9c0\ub9cc \uc778\uc2a4\ud134\uc2a4 \ub9ac\ud3ec\ud2b8\uc758 \uba87\uac00\uc9c0 \uc9c0\ud45c\ub97c \ubcf4\uace0 \uc801\uc808\ud55c \uc124\uc815\uc744 \ud558\ub294 \uc77c\ub4e4 \uc704\uc8fc\uc600\uace0, SQL\uc740 \uc774\ubbf8 \uc9dc\uc5ec\uc9c4 \ucffc\ub9ac\ub97c \uac04\ub2e8\ud788 \ubcc0\ud615\ud574\ubcf4\ub294 \uc815\ub3c4\uc774\uac70\ub098 \uc2dc\uc2a4\ud15c \uce74\ud0c8\ub85c\uadf8\ub97c \ub4a4\uc9c0\ub294 \uc815\ub3c4\uc758 \ucffc\ub9ac \ubc16\uc5d0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,160],"tags":[],"class_list":["post-1425","post","type-post","status-publish","format-standard","hentry","category-mysql","category-sql"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1425"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1425\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}