{"id":6204,"date":"2024-08-06T15:04:22","date_gmt":"2024-08-06T15:04:22","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=6204"},"modified":"2026-04-20T04:31:04","modified_gmt":"2026-04-20T04:31:04","slug":"1%ec%a3%bc%ec%b0%a8-2","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=6204","title":{"rendered":"1\uc8fc\ucc28"},"content":{"rendered":"

https:\/\/cafe.naver.com\/thisismysql<\/p>\n

\uc0d8\ud50c\uc790\ub8cc\ub2e4\uc6b41<\/a><\/p>\n

\uc0d8\ud50c\uc790\ub8cc\ub2e4\uc6b42<\/a><\/p>\n

 <\/p>\n

c:\\employees\\ \uc555\ucd95\ud480\uae30\r\n\r\ncmd \ud654\uba74 \uc774\ub3d9\r\n----\r\ncd ..\r\ncd employees\r\n\r\n\r\nmysql -u root -p  \r\n****\r\nmysql > show databases;\r\nmysql > source employees.sql  \r\n<\/pre>\n
 <\/p>\n
MYSQL PATH\ub4f1\ub85d<\/p>\n
SETX PATH “C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin;%PATH%”;<\/p>\n
 <\/p>\n
 <\/p>\n
\n
\uad50\uc7ac\ub9c1\ud06c<\/p>\n
https:\/\/www.yes24.com\/Product\/Goods\/90118480<\/a><\/p>\n
\"\"<\/p>\n
\n
sql \uc11c\ubc84<\/p>\n
– MySQL (\ubd80\ubd84\ubb34\ub8cc, \uc624\ub77c\ud074\uc5d0 \uc778\uc218)
\n– mariaDB (\uc644\uc804\ubb34\ub8cc) ->
\n—————————-
\n– \uc624\ub77c\ud074 (\ub9e4\uc6b0 \ube44\uc2f8\ub2e4)
\n– MSSQL (ms) \uc624\ub85c\uc9c0 \uac8c\uc784\ud68c\uc0ac
\n– DB2
\n– PostgreSQL
\n———————-
\n\ud55c\uad6d\uc0b0
\n\ud2f0\ubca0\ub85c, \ud050\ube0c\ub9ac\ub4dc
\n————————-
\n\uc6cc\ud06c\ubca4\uce58 mysql workbench8.x (\ub85c\uceec\uc804\uc6a9)
\nphpmyadmin
\nDBeaver
\n——————————
\nNoSQL (No Structured Query Language)
\n\ubabd\uace0DB
\n\ub808\ub514\uc2a4
\n\ud558\ub461
\n\ud30c\uc774\uc5b4\ubca0\uc774\uc2a4
\nSQLite<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
https:\/\/cafe.naver.com\/thisismysql \uc0d8\ud50c\uc790\ub8cc\ub2e4\uc6b41 \uc0d8\ud50c\uc790\ub8cc\ub2e4\uc6b42   c:\\employees\\ \uc555\ucd95\ud480\uae30 cmd \ud654\uba74 \uc774\ub3d9 —- cd .. cd employees mysql -u root -p **** mysql > show databases; mysql > source employees.sql   MYSQL PATH\ub4f1\ub85d…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-6204","post","type-post","status-publish","format-standard","category-mysql"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/6204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6204"}],"version-history":[{"count":5,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/6204\/revisions"}],"predecessor-version":[{"id":7567,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/6204\/revisions\/7567"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}