#7 MySQL

#7.0 Introduction

MySQL MySQL은 μ„Έκ³„μ—μ„œ κ°€μž₯ 많이 μ“°μ΄λŠ” μ˜€ν”ˆ μ†ŒμŠ€μ˜ κ΄€κ³„ν˜• λ°μ΄ν„°λ² μ΄μŠ€ 관리 μ‹œμŠ€ν…œ. 닀쀑 μŠ€λ ˆλ“œ, 닀쀑 μ‚¬μš©μž, κ΅¬μ‘°μ§ˆμ˜μ–΄ ν˜•μ‹μ˜ λ°μ΄ν„°λ² μ΄μŠ€ 관리 μ‹œμŠ€ν…œμœΌλ‘œ 였라클이 관리 및 μ§€μ›ν•˜κ³  있으며, Qt처럼 이쀑 λΌμ΄μ„ μŠ€κ°€ 적용됨 https://www.mysql.com

MariaDB MariaDBλŠ” μ˜€ν”ˆ μ†ŒμŠ€μ˜ κ΄€κ³„ν˜• λ°μ΄ν„°λ² μ΄μŠ€ 관리 μ‹œμŠ€ν…œ. MySQLκ³Ό λ™μΌν•œ μ†ŒμŠ€ μ½”λ“œ(MySQLμ—μ„œ fork)λ₯Ό 기반으둜 ν•˜λ©°, GPL v2 λΌμ΄μ„ μŠ€λ₯Ό λ”°λ₯Έλ‹€. 였라클 μ†Œμœ μΈ MySQL의 λΆˆν™•μ‹€ν•œλΌμ΄μ„ΌμŠ€ μƒνƒœμ— λ°˜λ°œν•˜μ—¬ λ§Œλ“€μ–΄μ‘ŒμœΌλ©°, λ°°ν¬μžλŠ” λͺ¬ν‹° ν”„λ‘œκ·Έλž¨ AB와 μ €μž‘κΆŒμ„ κ³΅μœ ν•΄μ•Ό ν•œλ‹€. https://mariadb.org

#7.1 Installation

MySQL μ„€μΉ˜

#7.2 MySQLWorkbench

MySQLWorkbench μ„€μΉ˜

#7.3 Connecting

Beekeeper Stuidio와 μ—°κ²°

#7.4 MySQL Data Types Part One

데이터 νƒ€μž…μ„ 톡해 μ •ν™•νžˆ μ–΄λ–€ μ’…λ₯˜μ˜ 데이터가 ν…Œμ΄λΈ”μ— λ“€μ–΄μ˜¬ 수 μžˆλŠ”μ§€ λͺ…ν™•νžˆ ν•  수 있음

#7.5 MySQL Data Types Part Two

#7.6 Insert Into Values

#7.7 ALTER TABLE

#7.8 ALTER TABLE Part Two

#7.9 Generated Columns

λ‹€λ₯Έ μ»¬λŸΌμ„ μ‚¬μš©ν•˜μ—¬ 값을 λ„μΆœν•˜λŠ” 컬럼

#7.10 Data Import

Last updated

Was this helpful?