๐Ÿ“–
Mini's Today I Learned
  • Today I Learned
  • ๐Ÿ’ปComputer Science
    • ๐ŸงฑComputer Science
      • Computer Architecture
    • ๐Ÿฆ•OperatingSystem
      • System Structure
      • 01. ์šด์˜์ฒด์ œ ์—ญํ• 
      • 02. History๋กœ ์ดํ•ดํ•˜๋Š” ์šด์˜์ฒด์ œ
      • 03. ์šด์˜์ฒด์ œ ๊ตฌ์กฐ
      • 04. ํ”„๋กœ์„ธ์Šค ์Šค์ผ€์ฅด๋ง
      • 05. ์Šค์ผ€์ฅด๋ง ์•Œ๊ณ ๋ฆฌ์ฆ˜
      • 06. ํ”„๋กœ์„ธ์Šค ์ƒํƒœ์™€ ์Šค์ผ€์ฅด๋Ÿฌ
      • 07. ์ธํ„ฐ๋ŸฝํŠธ
      • 08. ํ”„๋กœ์„ธ์Šค์™€ ์ปจํ…์ŠคํŠธ ์Šค์œ„์นญ
      • 09. ํ”„๋กœ์„ธ์Šค๊ฐ„ ์ปค๋ฎค๋‹ˆ์ผ€์ด์…˜(IPC ๊ธฐ๋ฒ•)
      • 10. Thread(์Šค๋ ˆ๋“œ)
      • 11. ๊ฐ€์ƒ๋ฉ”๋ชจ๋ฆฌ (Virtual Memory System)
      • 12. ํŒŒ์ผ์‹œ์Šคํ…œ ์ดํ•ด
      • 13. ๋ถ€ํŒ…์˜ ์ดํ•ด
      • 14. ๊ฐ€์ƒ๋จธ์‹ (Virtual Machine)
  • ๐Ÿ“ˆDatabase
    • MySQL CLI (Frequently used)
    • 1-Tier, 2Tier, 3Tier
    • Basic SQL
    • Built in function
    • Sub Query
    • View
    • Stored Program
    • index
    • Normalization(์ •๊ทœํ™”)
    • Transaction
    • Transaction
  • ๐ŸŒ Network
    • ๐Ÿ”Œ TCP&IP Basic
      • 01 TCP/IP ๋ง›๋ณด๊ธฐ
      • 02 TCP/IP ๊ฐœ์š”
      • 03 ํ†ต์‹  ์„œ๋น„์Šค์™€ ํ”„๋กœํ† ์ฝœ
      • 04 ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๊ณ„์ธต
      • 05 ํŠธ๋ Œ์ŠคํฌํŠธ ๊ณ„์ธต
      • 06 ๋„คํŠธ์›Œํฌ๊ณ„์ธต
      • 07 ๋ฐ์ดํ„ฐ ๊ณ„์ธต๊ณผ ๋ฌผ๋ฆฌ๊ณ„์ธต
      • 08 ๋ผ์šฐํŒ…
      • 09 ๋ณด์•ˆ
      • 10 HTTP ํ”„๋กœํ† ์ฝœ
    • ๐Ÿฟ๏ธHTTP ์™„๋ฒฝ ๊ฐ€์ด๋“œ ์š”์•ฝ
      • 1. HTTP: ์›น์˜ ๊ธฐ์ดˆ
      • 2. URL ๊ณผ ๋ฆฌ์†Œ์Šค
      • 3. HTTP Message
      • 4. Connection Management
      • 5. Overview of web server architectures
      • 6. Proxies
      • 7.Caching
      • 8. Integration Points: Gateways, Tunnels, and Relays
      • 9. Web Robots
      • 10. HTTP/2.0
      • 11. Client Identification and Cookies
      • 12. Basic Authentication
      • 13. Digest Authentication
      • 14. Secure HTTP
      • 15. Entities and Encodings
      • 16. Internationalization
      • 17. Content Negotiation and Transcoding
      • 18. Web Hosting
  • ๐ŸดLanguage
    • โ˜•JAVA
      • Comparable vs Comparator
  • ๐Ÿ› ๏ธ Framework
  • ๐ŸงฉDesign Pattern
    • ๊ฐ์ฒด ์ง€ํ–ฅ ์„ค๊ณ„ ์›์น™ (SOLID)
    • Design Pattern ๊ฐœ์š”
    • Template method
    • Singleton
  • ๐ŸฅFrontEnd
    • HTML&CSS
      • 01 Intro
      • 02 HTML Basic
      • 03 Content Section
      • 04 Block and Inline Elements
      • 05 Text Contents
      • 06 Inline Elements
      • 07 Multi Media
      • 08 Table&Form&etc
      • 09 Global Attribute & etc
      • 10 css basic
      • 11 css config
      • 12 css unit
      • 13 Box Model
      • 14 Font & Text
      • 15 Float(๋„์›€) & Position
      • 16 Background
      • 17 Transitions & Transforms
      • 18 Animation & Multi Columns(๋‹ค๋‹จ)
      • 19 Flex
      • 20 Grid
    • Sass(SCSS)
    • TypeScript
    • Webpack Introduction
      • ์›นํŒฉ์˜ ๊ธฐ๋ณธ ๊ตฌ์กฐ
      • CommonJS
      • ESM
      • WebpackConfig
        • 1. Handlebars
        • 2. Caching
        • 3. Minification & Mangling
        • 4. Mode(Development mode & Production Mode)
        • 5. ์ด๋ฏธ์ง€ ํŒŒ์ผ ๋ชจ๋“ˆ๋กœ ๋‹ค๋ฃจ์–ด๋ณด๊ธฐ(file-loader)
        • 6. ์ด๋ฏธ์ง€ ํŒŒ์ผ ๋ชจ๋“ˆ๋กœ ๋‹ค๋ฃจ์–ด๋ณด๊ธฐ(url-loader)
        • 7. SASS Loader
        • 8. Post CSS
        • 9. BLOWSERS LIST
        • 10. Stylelint
        • 11. Babel
      • Webpack-Practice
    • ETC
      • GIT
      • MarkDown
Powered by GitBook
On this page
  • ๋ทฐ์˜ ์ƒ์„ฑ
  • ๋ทฐ์˜ ์ˆ˜์ •
  • ๋ทฐ์˜ ์‚ญ์ œ
  • ์‹œ์Šคํ…œ ๋ทฐ

Was this helpful?

  1. Database

View

  • ํ•˜๋‚˜ ์ด์ƒ์˜ ํ…Œ์ด๋ธ”์„ ํ•ฉํ•˜์—ฌ ๋งŒ๋“  ๊ฐ€์ƒ์˜ ํ…Œ์ด๋ธ”

  • ์งˆ์˜์˜ ๊ฒฐ๊ณผ ๋งŒ๋“ค์–ด์ง€๋Š” ๊ฐ€์ƒ์˜ ํ…Œ์ด๋ธ”๋กœ, ์‹ค์ œ ํ…Œ์ด๋ธ” ์ฒ˜๋Ÿผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค.

  • ์‹ค์ œ ๋””์Šคํฌ์—๋Š” ์ €์žฅ๋˜์ง€ ์•Š๊ณ , ๋ทฐ ์ƒ์„ฑ์‹œ ์‚ฌ์šฉํ•œ select ๋ฌธ์˜ ์ •์˜๋ฅผ DBMS๊ฐ€ ์ €์žฅํ•œ๋‹ค.

  • ์žฅ์ 

    • ํŽธ๋ฆฌ์„ฑ & ์žฌ์‚ฌ์šฉ์„ฑ:

      • ๋ฏธ๋ฆฌ ์ •์˜๋œ ๋ทฐ๋ฅผ ์ผ๋ฐ˜ ํ…Œ์ด๋ธ”์ฒ˜๋Ÿผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๊ธฐ ๋•Œ๋ฌธ์— ํŽธ๋ฆฌ.

      • ์‚ฌ์šฉ์ž๊ฐ€ ํ•„์š”ํ•œ ์ •๋ณด๋งŒ ์š”๊ตฌ์— ๋งž๊ฒŒ ๊ฐ€๊ณตํ•˜์—ฌ ๋ทฐ๋กœ ๋งŒ๋“ค์–ด ์“ธ ์ˆ˜ ์žˆ๋‹ค.

      • ์ž์ฃผ ์‚ฌ์šฉ๋˜๋Š” ์งˆ์˜๋ฅผ ๋ทฐ๋กœ ๋ฏธ๋ฆฌ ์ •์˜ํ•ด ์žฌ์‚ฌ์šฉ์ด ๊ฐ€๋Šฅํ•˜๋‹ค.

    • ๋ณด์•ˆ์„ฑ

      • ๊ฐ ์‚ฌ์šฉ์ž๋ณ„๋กœ ๋ณด์•ˆ์ด ํ•„์š”ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ์ œ์™ธํ•˜์—ฌ ์„ ๋ณ„ํ•˜์—ฌ ๋ณด์—ฌ์ค„ ์ˆ˜ ์žˆ๋‹ค.

    • ๋…๋ฆฝ์„ฑ

      • ๋…ผ๋ฆฌ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ์›๋ณธ ํ…Œ์ด๋ธ”์˜ ๊ตฌ์กฐ๊ฐ€ ๋ณ€ํ•ด๋„, ์‘์šฉํ”„๋กœ๊ทธ๋žจ์— ์˜ํ–ฅ์„ ์ฃผ์ง€ ์•Š๋„๋ก ํ•˜๋Š” ๋…ผ๋ฆฌ์  ๋…๋ฆฝ์„ฑ์„ ์ œ๊ณต.

  • SELECT ๋ฌธ์„ ์ œ์™ธํ•œ ์ผ๋ถ€ ๋ฌผ๋ฆฌ์ ์ธ ํ…Œ์ด๋ธ”์˜ ๊ฐฑ์‹ ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•˜๋Š”๋ฐ ์ œ์•ฝ์ด ์žˆ๋‹ค.

  • ๊ธฐ๋ณธํ‚ค๋ฅผ ํฌํ•จํ•˜์ง€ ์•Š๋Š” ์ˆ˜์ • ์š”์ฒญ์ด๋‚˜, ํ…Œ์ด๋ธ” 2๊ฐœ ์ด์ƒ์—์„œ ์†์„ฑ์„ ํฌํ•จํ•˜๋Š” ์ˆ˜์ •์š”์ฒญ์€ ์ œ์•ฝ์„ ์œ„ํ•œ ํ•  ๊ฐ€๋Šฅ์„ฑ์ด ์žˆ์œผ๋ฏ€๋กœ ๊ฐฑ์‹ ์ž‘์—… ์ œ์•ฝ์ด ์žˆ๋‹ค.

๋ทฐ์˜ ์ƒ์„ฑ

  • CREATE VIEW ๋ทฐ์ด๋ฆ„ [(์—ด์ด๋ฆ„ [, ... n])]
    AS SELECT ๋ฌธ
    
    -- ์˜ˆ์‹œ
    create view vw_book
    as select * 
    from book
    where bookname like '%์ถ•๊ตฌ%';
  • ๋ทฐ์ด๋ฆ„: ์ƒ์„ฑํ•  ๋ทฐ์˜ ์ด๋ฆ„

  • ์—ด์ด๋ฆ„: ๋ทฐ์—์„œ ์‚ฌ์šฉํ•  ์—ด์˜ ์ด๋ฆ„

  • ์—ด ์ด๋ฆ„๊ณผ select๋ฌธ์—์„œ ์ถ”์ถœํ•˜๋Š” ์†์„ฑ์€ 1:1 ๋Œ€์‘

๋ทฐ์˜ ์ˆ˜์ •

  • ๋ฌผ๋ฆฌ์ ์ธ ํ…Œ์ด๋ธ”์˜ ์ˆ˜์ •์ž‘์—…๊ณผ ๋งˆ์ฐฌ๊ฐ€์ง€๋กœ, ๋ทฐ๋„ ํ•„์š”์— ๋”ฐ๋ผ ์ •์˜๋œ SQL๋ฌธ์˜ ์ˆ˜์ •์ด ํ•„์š”.

  • ๋ทฐ์˜ ์ˆ˜์ •์€ CREATE VIEW๋ฌธ์— OR REPLACE๋ช…๋ น์„ ๋”ํ•˜์—ฌ ์ž‘์„ฑ

    CREATE OR REPLACE VIEW ๋ทฐ์ด๋ฆ„ [(์—ด์ด๋ฆ„ [, ... n])]
    AS SELECT๋ฌธ
    
    --์˜ˆ
    create or replace view vw_orders (custid, name, address)
    as select custid, name, address
    from customer
    where address like '%์˜๊ตญ%';

๋ทฐ์˜ ์‚ญ์ œ

  • DROP VIEW ๋ทฐ์ด๋ฆ„ [,...n];
    
    --์˜ˆ
    DROP VIEW vw_orders;

์‹œ์Šคํ…œ ๋ทฐ

  • DBMS๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ฐœ์ฒด(ํ…Œ์ด๋ธ”, ํ•จ์ˆ˜, ๋ทฐ ๋“ฑ)๋‚˜ ์‹œ์Šคํ…œ์˜ ํ†ต๊ณ„ ์ •๋ณด ๋“ฑ์„ ์‚ฌ์šฉ์ž๊ฐ€ ์ง์ ‘ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋„๋ก ์‹œ์Šคํ…œ ๋ทฐ๋ฅผ ๋งŒ๋“ค์–ด ์ œ๊ณตํ•œ๋‹ค.

  • ์‹œ์Šคํ…œ ๋ทฐ(=๋ฐ์ดํ„ฐ ๋”•์…”๋„ˆ๋ฆฌ ๋ทฐ, ์‹œ์Šคํ…œ ์นดํƒˆ๋กœ๊ทธ)

  • DBMS ๊ด€๋ จ ์ •๋ณด๋ฅผ ํ…Œ์ด๋ธ” ํ˜•ํƒœ๋กœ ๋งŒ๋“ค์–ด ์‹ค์‹œ๊ฐ„์œผ๋กœ ์ œ๊ณต.

  • ์‚ฌ์šฉ์ž๋“ค์€ ์‹œ์Šคํ…œ๋ทฐ๋ฅผ ์ฐธ์กฐํ•ด์„œ ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค ํŠœ๋‹, ๊ธฐํƒ€๋ฌธ์ œ๋“ค์„ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค.

  • MySQL ์‹œ์Šคํ…œ ๋ทฐ๋Š” INFORMATION_SCHEMA ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์ €์žฅ๋˜์–ด ์žˆ์œผ๋ฉฐ, SELECT ๋ช…๋ น์œผ๋กœ ์กฐํšŒํ•  ์ˆ˜ ์žˆ๋‹ค. ๋ฉ”๋‰ด์–ผ์„ ์ฐธ์กฐํ•˜์—ฌ ํ•„์š”ํ•œ ๋ทฐ๋ฅผ ์ฐพ์•„ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค.

    SELECT * FROM INFORMATION_SCHEMA.TABLES
    WHERE table_schema like '์Šคํ‚ค๋งˆ์ด๋ฆ„';
    
    --์œ„ ์งˆ์˜๋ฌธ์€ ์•„๋ž˜ ๋ช…๋ น๊ณผ ๊ฐ™๋‹ค.
    show tables;
PreviousSub QueryNextStored Program

Last updated 4 years ago

Was this helpful?

๐Ÿ“ˆ