๐Ÿ’› ํ”„๋กœ๊ทธ๋ž˜๋ฐ 43

[Git] VScode ์—์„œ ๊นƒํ—ˆ๋ธŒ ๋ธŒ๋žœ์น˜ ๋งŒ๋“ค๊ธฐ

vscode์—์„œ ๊นƒํ—ˆ๋ธŒ ๋ธŒ๋žœ์น˜ ๋งŒ๋“œ๋Š” ๋ฐฉ๋ฒ•! 1. Ctrl + Shift + p, git ๊ฒ€์ƒ‰ 2. create branch ์„ ํƒ 3. ๋ธŒ๋žœ์น˜ ์ด๋ฆ„ ๋„ฃ์–ด์ฃผ๊ณ  ์—”ํ„ฐ! 4. ๊นƒ ์ „ํ™˜ ๋ฐฉ๋ฒ• git checkout ๋ธŒ๋žœ์น˜์ด๋ฆ„ ๋ธŒ๋žœ์น˜ ๋ฐ”๊พธ๊ธฐ ์„ฑ๊ณต!

SQL) UNION / UNION ALL ์ฐจ์ด์  ๋ฐ ์‚ฌ์šฉ ๋ฐฉ๋ฒ•

UNION ์ด๋ž€? ์—ฌ๋Ÿฌ ๊ฐœ์˜ sql๋ฌธ์„ ํ•ฉ์ณ ํ•˜๋‚˜์˜ sql๋ฌธ์œผ๋กœ ๋งŒ๋“ค์–ด์ฃผ๋Š” ๋ฐฉ๋ฒ• โ€‹ UNION vs. UNION ALL ๊ณตํ†ต์  ์ฐจ์ด์  ๋‘ ์ฟผ๋ฆฌ๋ฌธ์„ ํ•˜๋‚˜๋กœ ํ•ฉ์ณ์ค€๋‹ค. UNION - ์ค‘๋ณต๋œ ๊ฐ’์„ ์ œ๊ฑฐํ•ด์„œ ์•Œ๋ ค์ค€๋‹ค. - ์ค‘๋ณต ์ œ๊ฑฐ๋ฅผ ์œ„ํ•œ ์—ฐ์‚ฐ์„ ํ•œ ๋ฒˆ ๋” ํ•˜๊ธฐ ๋•Œ๋ฌธ์— UNION ALL๋ณด๋‹ค ์†๋„๊ฐ€ ๋Š๋ฆฌ๋‹ค. UNION ALL - ์ค‘๋ณต๋œ ๊ฐ’๋„ ๋ชจ๋‘ ๋ณด์—ฌ์ค€๋‹ค. โ€ป ์ปฌ๋Ÿผ๋ช…์ด ๊ฐ™์•„์•ผํ•œ๋‹ค. (๊ฐ™์ง€ ์•Š์€ ๊ฒฝ์šฐ AS๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๊ฐ™๊ฒŒํ•ด์ฃผ์–ด์•ผํ•จ) โ€ป ์ปฌ๋Ÿผ๋ณ„ ๋ฐ์ดํ„ฐ ํƒ€์ž…์ด ๊ฐ™์•„์•ผํ•œ๋‹ค. โ€‹ ์‚ฌ์šฉ๋ฒ• โ€ปโ€ป์ปฌ๋Ÿผ๋ช…์ด ๊ฐ™์„ ๋•Œ SELECT * FROM [ํ…Œ์ด๋ธ”1] UNION SELECT * FROM [ํ…Œ์ด๋ธ”2]; SELECT * FROM [ํ…Œ์ด๋ธ”1] UNION ALL SELECT * FROM [ํ…Œ์ด๋ธ”2]; โ€‹ โ€ปโ€ป์ปฌ๋Ÿผ๋ช…์ด ๊ฐ™์ง€ ์•Š์„ ๋•Œ SE..

[Java]Spring ์—๋Ÿฌ ํ•ด๊ฒฐ๋ฒ• : cvc-complex-type.2.3: Element 'bean' cannot have character [children], because the type's content type is element-only.

๊ณผ์ œ๋ฅผ ์œ„ํ•ด xmlํŒŒ์ผ์˜ ์ด๊ณณ์ €๊ณณ์„ ๊ฑด๋“ค์ด๋‹ค๊ฐ€ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค... cvc-complex-type.2.3: Element 'bean' cannot have character [children],because the type's content type is element-only. ๊ฒ€์ƒ‰์„ ํ•ด๋ณด๋‹ˆ ์›์ธ์ด ์—ฌ๋Ÿฌ๊ฐœ๊ฐ€ ์žˆ์—ˆ๋‹ค. ์›์ธ 1. ์˜ ๋ˆ„๋ฝ : ํ•ด๋‹น ๋ถ€๋ถ„์„ ์ƒ๋‹จ์— ์ถ”๊ฐ€ํ•ด์ฃผ๊ธฐ 2. ์ดํด๋ฆฝ์Šค ์ƒ์˜ ๋ฌธ์ œ : ์ดํด๋ฆฝ์Šค๋ฅผ ๊ป๋‹ค๊ฐ€ ์ผœ๋ณด๊ธฐ 3. ์˜คํƒ€ : ์–ด๋”˜๊ฐ€์— ์˜คํƒ€๊ฐ€ ์žˆ์„ ๊ฒƒ์ด๋‹ˆ ์ž˜ ์‚ดํŽด๋ณด๊ธฐ ๋‚˜๊ฐ™์€ ๊ฒฝ์šฐ๋Š” ์˜คํƒ€์˜€๋‹ค.. ์ฃผ์„์ฒ˜๋ฆฌ๋ฅผ ํ–ˆ๋‹ค๊ฐ€ ์ฃผ์„์„ ์—†์• ๋Š” ๊ณผ์ •์—์„œ -->๋ฅผ ์—†์• ์ง€ ์•Š์•„ ๋ฐœ์ƒํ–ˆ๋˜ ๊ฒƒ. --> ๋ถ€๋ถ„์„ ์—†์• ์ฃผ๋‹ˆ ์ •์ƒ ์ž‘๋™๋˜์—ˆ๋‹ค. ์—ฌํŠผ ์˜คํƒ€๊ฐ€ ๋ฌธ์ œ^~^,,, ๊ทผ๋ฐ ์ด๊ฑธ ํ•ด๊ฒฐํ–ˆ๋”๋‹ˆ ๋‹ค๋ฅธ๊ณณ์—์„œ ๋˜ ์˜ค๋ฅ˜๋‚˜๋„ค..

Docker์— MongoDB ์„ค์น˜ํ•˜๋Š” ๋ฐฉ๋ฒ•๐Ÿ”จ

์•ˆ๋…•ํ•˜์„ธ์š” ์ด๋ฒˆ์—” Docker์— MongoDB๋ฅผ ์„ค์น˜ํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ์•Œ๋ ค๋“œ๋ฆด๊ฒŒ์š” 1. Mongo ์ด๋ฏธ์ง€ ๊ฐ€์ ธ์˜ค๊ธฐ docker pull mongo ์ž˜ ๋˜์—ˆ๋Š”์ง€ ํ™•์ธ docker image list 2. MongoDB Container ์ƒ์„ฑ docker run --name mongoDB -p 27017:27017 mongo 3. Docker ํ”„๋กœ์„ธ์Šค ํ™•์ธ docker ps 4. Container ์ ‘์† docker exec -it mongoDB /bin/bash 5. mongo๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ์ œ๋Œ€๋กœ ๋™์ž‘ํ•˜๋Š”์ง€ ํ™•์ธ ์ž˜ ๋™์ž‘ํ•˜๋„ค์š”! ๋ !

์•Œ๊ณ ๋ฆฌ์ฆ˜ ๊ณต๋ถ€ํ•˜๊ธฐ ์ข‹์€ ์‚ฌ์ดํŠธ ์ถ”์ฒœโœจ๋ฐฑ์ค€ ์•Œ๊ณ ๋ฆฌ์ฆ˜

์•ˆ๋…•ํ•˜์„ธ์š” ์•Œ๊ณ ๋ฆฌ์ฆ˜ ๊ณต๋ถ€ํ•˜๊ธฐ ์ข‹์€ ์‚ฌ์ดํŠธ๋ฅผ ์ถ”์ฒœํ•ด๋“œ๋ฆฌ๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค. ๋ฐ”๋กœ "๋ฐฑ์ค€"์ธ๋ฐ์š”! https://www.acmicpc.net/ ๋ฉ”๋‰ด๋ฅผ ์—ด์–ด๋ณด๋ฉด ์ข…๋ฅ˜๊ฐ€ ๋งค์šฐ ๋‹ค์–‘ํ•˜๊ฒŒ ์žˆ์Šต๋‹ˆ๋‹ค. ๋˜ํ•œ ํšŒ์›๊ฐ€์ž…ํ›„ ๋ฌธ์ œ๋ฅผ ํ’€๋ฉด ๋‚ด๊ฐ€ ํ‘ผ ๋ฌธ์ œ๋‚ด์—ญ์„ ํ™•์ธ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์–ธ์–ด๋„ ๋‹ค์–‘ํ•˜๊ฒŒ ์žˆ์œผ๋‹ˆ, ์›ํ•˜๋Š” ์–ธ์–ด๋กœ ์†Œ์Šค๋ฅผ ์ž‘์„ฑํ•˜๋ฉด ๋  ๊ฒƒ ๊ฐ™์Šต๋‹ˆ๋‹ค.

๐ŸณDocker๋ฅผ Windows 10 Home์— ์„ค์น˜ํ•˜๊ธฐ๐Ÿณ

์•ˆ๋…•ํ•˜์„ธ์š” ์˜ค๋Š˜์€ ์ˆ˜์—…์‹œ๊ฐ„์— ์‚ฌ์šฉํ•  Docker Desktop์„ ๋‹ค์šด๋ฐ›์•„๋ณผ๊ฑฐ์—์š”. ์ €๋Š” Microsoft Windows 10 Home ์ด๊ธฐ ๋•Œ๋ฌธ์— Windows 10 Home์—์„œ ๋‹ค์šด๋ฐ›๋Š” ๋ฒ•์„ ์„ค๋ช…๋“œ๋ฆด๊ฒŒ์š” โ— โ— โ— PowerShell์—์„œ ๋‹ค์Œ ์†Œ์Šค๋ฅผ ์ž…๋ ฅํ•˜์‹œ๋ฉด ์ž์‹ ์˜ windows๋ฒ„์ „์„ ์•Œ ์ˆ˜ ์žˆ์–ด์š”! Get-WmiObject -Class Win32_OperatingSystem | % Caption ๋จผ์ € ๋„์ปค ํˆด๋ฐ•์Šค๋ฅผ ๋‹ค์šด๋ฐ›์•„์ค๋‹ˆ๋‹ค. ๐Ÿ”ฝ๐Ÿ”ฝ Docker ToolBox ๋‹ค์šด๋กœ๋“œ ๋งํฌ ๐Ÿ”ฝ๐Ÿ”ฝ https://docs.docker.com/toolbox/toolbox_install_windows/ ์‹คํ–‰ํŒŒ์ผ์„ ๋‹ค์šด๋ฐ›์•„ ์‹คํ–‰์‹œ์ผœ์ค๋‹ˆ๋‹ค. Next > Git ์ด ๋‹ค์šด๋˜์–ด์žˆ์ง€ ์•Š๋‹ค๋ฉด ์ฒดํฌํ•ด์ฃผ์„ธ์š”! Next > Next > ..

[๋ฆฌ๋ˆ…์Šค/CentOS] PHP 7.3 ์„ค์น˜ ๋ฐฉ๋ฒ•๐Ÿ’ป

์•ˆ๋…•ํ•˜์„ธ์š” ์ด๋ฒˆ์—” ์„œ๋ฒ„์— PHP๋ฅผ ์„ค์น˜ํ•ด๋ณผ๊ฒŒ์š” 1. epel ๋ฐ remi ์†Œํ”„ํŠธ์›จ์–ด ์†Œ์Šค ์„ค์น˜ yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm yum install https://rpms.remirepo.net/enterprise/remi-release-7.rpm 2. yum-utils ๋„๊ตฌ ์„ค์น˜ํ•˜๊ธฐ yum -y install yum-utils 3. PHP์˜ ๊ธฐ๋ณธ ์„ค์น˜ ๋ฒ„์ „์„ 7.3์œผ๋กœ ์ง€์ •ํ•˜๊ธฐ yum-config-manager --enable remi-php73 4. PHP7.3 ๋ฐ ์ผ๋ฐ˜ ํ™•์žฅ ์„ค์น˜ํ•˜๊ธฐ yum -y install php php-common php-fpm yum -y install php-..

๐Ÿ”จ[๋ฆฌ๋ˆ…์Šค/CentOS] Apache ์„ค์น˜ํ•˜๊ธฐ๐Ÿ”จ

์•ˆ๋…•ํ•˜์„ธ์š” ์ด๋ฒˆ์—” CentOS์— Apache ์›น์„œ๋ฒ„๋ฅผ ์„ค์น˜ํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ํฌ์ŠคํŒ…ํ•˜๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค. 0. ์ ‘์†ํ•˜๊ธฐ 1. yum์„ update ์‹œ์ผœ์ค€๋‹ค. yum -y update (์œ„ ์ฝ”๋“œ์—์„œ -y๋Š” ์„ค์น˜์—ฌ๋ถ€๋ฅผ ๋ฌผ์–ด๋ณผ๋•Œ yes๋ฅผ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค. ์ผ์ผ์ด y๋ฅผ ์ž…๋ ฅํ•˜์ง€์•Š์•„๋„ ๋จ. ) ์—…๋ฐ์ดํŠธ ๋‚ด์šฉ์ด ๋งŽ์•˜๋Š”์ง€ ์‹œ๊ฐ„์ด ๊ฝค ์˜ค๋ž˜ ๊ฑธ๋ ธ์Šต๋‹ˆ๋‹ค...ใ…  Complete! ๊ฐ€ ๋–ด๋‹ค๋ฉด ์™„๋ฃŒ! 2. ๋ฐฉํ™”๋ฒฝ ์„ค์น˜ yum install firewalld 3. ๋ฐฉํ™”๋ฒฝ ์‹คํ–‰ sudo systemctl start firewalld // ๋ฐฉํ™”๋ฒฝ ์‹คํ–‰ firewall-cmd --state // ์ƒํƒœ ํ™•์ธ sudo systemctl enable firewalld // ๋ถ€ํŒ…์‹œ ์ž๋™์‹œ์ž‘ 4. yum์„ ์ด์šฉํ•ด์„œ Apache๋ฅผ ์„ค์น˜ yum -y ins..

์ดํด๋ฆฝ์Šค ํ”„๋กœ์ ํŠธ๋ฅผ GitHub ์›๊ฒฉ์ €์žฅ์†Œ์— ์˜ฌ๋ฆฌ๊ธฐ๐Ÿ”‘Commit & Push

์•ˆ๋…•ํ•˜์„ธ์š” ์ดํด๋ฆฝ์Šค์—์„œ ํ”„๋กœ์ ํŠธ๋ฅผ GitHub์— ์˜ฌ๋ฆฌ๋Š” ๋ฐฉ๋ฒ•์„ ์•Œ๋ ค๋“œ๋ฆด๊ฒŒ์š”! 1. GitHub์— ์˜ฌ๋ฆฌ๊ณ  ์‹ถ์€ ํ”„๋กœ์ ํŠธ๋ฅผ ์šฐํด๋ฆญํ›„ Team -> Share Project๋ฅผ ๋ˆ„๋ฆ…๋‹ˆ๋‹ค. 2. Use or create repository inparent folder of project ์ฒดํฌ๋ฐ•์Šค๋ฅผ ํด๋ฆญ 3. ํ”„๋กœ์ ํŠธ๋ฅผ ํด๋ฆญํ•ด์ค€ ํ›„, Create Repository๋ฅผ ๋ˆ„๋ฆ…๋‹ˆ๋‹ค. Create Repository๋ฅผ ๋ˆ„๋ฅด๋ฉด Project์— ์ฒดํฌํ‘œ์‹œ๊ฐ€ ๋ฉ๋‹ˆ๋‹ค. ๊ทธ๋Ÿผ Finish ํด๋ฆญ Git Repositories์— ์›ํ•˜๋Š” ํ”„๋กœ์ ํŠธ๊ฐ€ ์˜ฌ๋ผ์™”๋‹ค๋ฉด ์„ฑ๊ณต์ž…๋‹ˆ๋‹ค. ๐Ÿ’ฅGit Repositories๊ฐ€ ๋ณด์ด์ง€ ์•Š์„๋•Œ๐Ÿ’ฅ window -> Show View -> Other ๊ฒ€์ƒ‰์ฐฝ์— git ์ž…๋ ฅํ•˜๋ฉด ๋œน๋‹ˆ๋‹ค! 4. ํ”„๋กœ์ ํŠธ๊ฐ€ ์ž˜ ๋งŒ๋“ค์–ด์ง„ ๊ฒƒ์„..

728x90
๋ฐ˜์‘ํ˜•