๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

โœ’๏ธ Database & DBMS/MySQL5

[MySQL & Spring Boot] ํšŒ์› ํ”„๋กœ์ ํŠธ _2~5) ์„œ๋ฒ„ ํฌํŠธ๋ฒˆํ˜ธ ์ง€์ • ~ ํšŒ์›๊ฐ€์ž… ๋กœ์ง ๊ตฌํ˜„ ๐Ÿ’™ ํšŒ์› ํ”„๋กœ์ ํŠธ _2~5) ์„œ๋ฒ„ ํฌํŠธ๋ฒˆํ˜ธ ์ง€์ •๋ถ€ํ„ฐ ํšŒ์›๊ฐ€์ž… ๋กœ์ง ๊ตฌํ˜„๊นŒ์ง€โ€ป ๋ณธ ํ”„๋กœ์ ํŠธ์™€ ๊ด€๋ จ๋œ ์ œ ๋ชจ๋“  ๊ฒŒ์‹œ๋ฌผ์€ ์ œ ๊ฐœ์ธ ๊ณต๋ถ€ ๊ธฐ๋ก ๋ชฉ์ ์œผ๋กœ ์ž‘์„ฑ๋˜์—ˆ์œผ๋ฉฐ, ์ž๋ฃŒ ์ถœ์ฒ˜๋Š” '์ฝ”๋”ฉ๋ ˆ์‹œํ”ผ'๋‹˜์˜ [์Šคํ”„๋ง๋ถ€ํŠธ ํšŒ์› ํ”„๋กœ์ ํŠธ] ์ž…๋‹ˆ๋‹ค! -->  https://www.youtube.com/watch?v=RhM1bQ76Tv0&list=PLV9zd3otBRt5ANIjawvd-el3QU594wyx7  1. application.yml ํŒŒ์ผ์—์„œ ์•„๋ž˜ ์ฝ”๋“œ๋ฅผ ํ†ตํ•ด ์„œ๋ฒ„ ํฌํŠธ๋ฒˆํ˜ธ ์ง€์ •server: port: 80812. HomeController.java ํŒŒ์ผ์—์„œ ๊ธฐ๋ณธ ํŽ˜์ด์ง€ ์š”์ฒญ ๋ฉ”์„œ๋“œ ๊ตฌํ˜„package com.codingrecipe.member.controller;import org.springframework.ste.. 2024. 5. 26.
[MySQL & Spring Boot] ํšŒ์› ํ”„๋กœ์ ํŠธ _1) ์ดˆ๊ธฐ ๊ฐœ๋ฐœํ™˜๊ฒฝ ์„ธํŒ… ๐Ÿ’™ ํšŒ์› ํ”„๋กœ์ ํŠธ _1) ์ดˆ๊ธฐ ๊ฐœ๋ฐœํ™˜๊ฒฝ ์„ธํŒ…โ€ป ๋ณธ ํ”„๋กœ์ ํŠธ์™€ ๊ด€๋ จ๋œ ์ œ ๋ชจ๋“  ๊ฒŒ์‹œ๋ฌผ์€ ์ œ ๊ฐœ์ธ ๊ณต๋ถ€ ๊ธฐ๋ก ๋ชฉ์ ์œผ๋กœ ์ž‘์„ฑ๋˜์—ˆ์œผ๋ฉฐ, ์ž๋ฃŒ ์ถœ์ฒ˜๋Š” '์ฝ”๋”ฉ๋ ˆ์‹œํ”ผ'๋‹˜์˜ [์Šคํ”„๋ง๋ถ€ํŠธ ํšŒ์› ํ”„๋กœ์ ํŠธ] ์ž…๋‹ˆ๋‹ค! -->  https://www.youtube.com/watch?v=RhM1bQ76Tv0&list=PLV9zd3otBRt5ANIjawvd-el3QU594wyx7  1. ์•„๋ž˜ ์ดˆ๊ธฐ ๊ฐœ๋ฐœ ํ™˜๊ฒฝ ์„ธํŒ…๊ฐœ๋ฐœ ํ™˜๊ฒฝLibrary of FrameworkOpen JDK 11 (Amazon Corretto 11)Spring Data JPAIntelliJ IDEA CommunitythymeleafMySQL Server 8.0.lombokSpring Boot 2.6.12gradle2. IntelliJ ์—์„œ Git Clone ํ•ด์˜ค๊ธฐ .. 2023. 11. 7.
[MySQL] MySQL ๋ช…๋ น๋ฌธ๊ณผ SQL ๋ฌธ๋ฒ• ๐Ÿก SQL(Structed Query Language) ๋ž€? ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ƒ์˜ ๋ฐ์ดํ„ฐ ๊ด€๋ฆฌ๋ฅผ ์œ„ํ•œ ์ฟผ๋ฆฌ ์–ธ์–ด๋ฅผ SQL(Structed Query Language)์ด๋ผ๊ณ  ํ•œ๋‹ค. ๋ชจ๋“  ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋Š” ๊ทธ ์ข…๋ฅ˜์— ๊ด€๊ณ„์—†์ด SQL(Structed Query Language)์„ ํ†ตํ•ด์„œ ๋ฐ์ดํ„ฐ๋ฅผ ๊ด€๋ฆฌํ•  ์ˆ˜ ์žˆ๋‹ค. ๐Ÿก MySQL ๋ช…๋ น๋ฌธ ์ •๋ฆฌ -- MySQL ๋ฒ„์ „ ํ™•์ธ mysql> select version(); -- ์ƒ์„ฑ๋˜์–ด ์žˆ๋Š” DB ๋ชฉ๋ก ํ™•์ธ mysql> show databases; -- DB ๋ชฉ๋ก์— ์žˆ๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ ํƒ mysql> use 'DB ๋ช…'; -- ์„ ํƒํ•œ DB์— ์กด์žฌํ•˜๋Š” table ๋ชฉ๋ก ์ถœ๋ ฅ mysql> show tables; -- ํŠน์ • ํ…Œ์ด๋ธ”์˜ ๊ตฌ์กฐ ์ถœ๋ ฅ mysql> desc '์ถœ๋ ฅํ•˜๊ณ ์ž ํ•˜๋Š” ํ…Œ์ด.. 2023. 6. 12.
[MySQL] MySQL Command Line Client์—์„œ ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ ์‹œ ์ข…๋ฃŒ๋˜๋Š” ํ˜„์ƒ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• # MySQL Command Line Client์—์„œ ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ ์‹œ ์ข…๋ฃŒ๋˜๋Š” ํ˜„์ƒ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• ๊ฐ„ํ˜น MySQL Command Line Client์—์„œ ํŒจ์Šค์›Œ๋“œ๋ฅผ ์ž…๋ ฅํ•œ ํ›„ ์•„๋ž˜ ์‚ฌ์ง„์ฒ˜๋Ÿผ ๋‚˜์˜ค์ง€ ์•Š๊ณ , ์ฐฝ์ด ์ง€์†ํ•ด์„œ ๋‹ซํžˆ๋Š” ํ˜„์ƒ์ด ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๋‹ค. ์˜ค๋Š˜์€ ์ด ๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ์ด์•ผ๊ธฐํ•ด๋ณด๊ณ ์ž ํ•œ๋‹ค. ๋ฌธ์ œ ํ•ด๊ฒฐ ์ ˆ์ฐจ๋Š” ์•„๋ž˜์™€ ๊ฐ™๋‹ค. 1. '์ž‘์—… ๊ด€๋ฆฌ์ž' ๋“ค์–ด๊ฐ€๊ธฐ (๋‹จ์ถ•ํ‚ค๋Š” Ctrl + Alt + Delete) 2. '์„œ๋น„์Šค' ํƒญ์— ๋“ค์–ด๊ฐ€๊ธฐ --> MySQL80 ์ฐพ์•„์„œ ๊ตฌ๋™์ด ์ค‘์ง€๋œ ์„œ๋ฒ„์˜ ์ƒํƒœ๋ฅผ '์‹คํ–‰ ์ค‘'์œผ๋กœ ๋ฐ”๊พธ๊ธฐ 3. ์ดํ›„ ๋‹ค์‹œ MySQL Command Line Client์—์„œ ํŒจ์Šค์›Œ๋“œ๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์€ ํ™”๋ฉด์ด ๋‚˜์˜ค๊ฒŒ ๋œ๋‹ค. 2023. 5. 14.
[MySQL] MySQL ์„ค์น˜ํ•˜๋Š” ๋ฐฉ๋ฒ• # MySQL ์„ค์น˜ํ•˜๋Š” ๋ฐฉ๋ฒ• 1. https://dev.mysql.com/ ์— ์ ‘์†ํ•œ ํ›„ DOWNLOADS ํƒญ ํด๋ฆญ 2. 'MySQL Community (GPL) Downloads' ์„ ํƒ ํ›„ 'MySQL Installer for Windows' ํด๋ฆญ 3. Download ๋ฒ„ํŠผ์„ ๋ˆŒ๋Ÿฌ Installer ๋‹ค์šด๋กœ๋“œ 4. Installer ์„ค์น˜ ํ›„ ์‹คํ–‰ --> 'Custom' ์„ ํƒ ํ›„ Next > ํด๋ฆญ 5. ์„ค์น˜ํ•  ์š”์†Œ๋“ค์„ ์šฐ์ธก์˜ ๋ฐ•์Šค๋กœ ์ด๋™ --> Next > ํด๋ฆญ 6. ์„ค์น˜ํ•  ๋ชฉ๋ก ํ™•์ธ ํ›„ Execute ํด๋ฆญ --> ๋‹ค์šด๋กœ๋“œ ์™„๋ฃŒ ํ›„ Next > ํด๋ฆญ 7. MySQL Root Password ๋ฅผ ์„ค์ •ํ•˜๊ณ , Repeat Password ์นธ์„ ์ฑ„์›Œ ๋น„๋ฐ€๋ฒˆํ˜ธ ํ™•์ธ --> Next > ํด๋ฆญ 8. ์•„๋ž˜์™€ ๊ฐ™์ด ๊ฐ’ ์„ค.. 2023. 5. 12.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”