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

๐Ÿ’ป Deep Wide Programming/Mysql & Database

Mysql ๋ณต์Šต

728x90
๋ฐ˜์‘ํ˜•

๋ณต์Šตํƒ€์ž„

1. mysql ์ ‘์†ํ•˜๊ธฐ

๋‚˜๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์„ค์ •ํ•˜์ง€ ์•Š์•˜๊ธฐ ๋•Œ๋ฌธ์— ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์ ‘์†ํ•œ๋‹ค. 

๋„์–ด์“ฐ๊ธฐ์— ์œ ์˜ํ•˜์ž..์ž๊พธ ์—๋Ÿฌ๊ฐ€ ๋‚˜์„œ ์ฒ˜์Œ์— ํ ์ง“ํ–ˆ๋‹ค.

2. ์ €์žฅ๋œ DB(์Šคํ‚ค๋งˆ) ์ฝ๊ธฐ: SHOW DATABASES;

 

3. DB(์Šคํ‚ค๋งˆ) ๋งŒ๋“ค๊ธฐ: CREATE DATABASE ______;

4. ์Šคํ‚ค๋งˆ ์ ‘์†ํ•˜๊ธฐ & ์Šคํ‚ค๋งˆ ๋‚ด์˜ ํ‘œ ํ™•์ธํ•˜๊ธฐ: USE _____;  /  show tables

 

5. ์Šคํ‚ค๋งˆ ๋‚ด์˜ ํ‘œ ๋ณด๊ธฐ: desc ____;

topic์ด๋ผ๋Š” ์ด๋ฆ„์˜ ๋งŒ๋“ค์–ด๋‘์—ˆ๋˜ ํ‘œ๋ฅผ ์—ด์—ˆ๋‹ค. 

6. table ๋‚ด์šฉ ํ™•์ธํ•˜๊ธฐ: SELECT * FROM ____;

 

7. ํ‘œ์— row(ํ–‰) ์ถ”๊ฐ€ํ•˜๊ธฐ: INSERT INTO _____(    ,   ,   ,   ,   ) VALUES ('   ', '  ', '  ', '  ', '  ');

๊ตฌ๊ธ€๋ง์„ ์ƒํ™œํ™”ํ•  ๊ฒƒ!

https://www.w3schools.com/sql/sql_select.asp

 

SQL SELECT Statement

SQL SELECT Statement The SQL SELECT Statement The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set. SELECT Syntax SELECT column1, column2, ... FROM table_name; Here, column1, colu

www.w3schools.com

8. SELECT ๋ฌธ

 

8-2. SELECT & WHERE

 

8-3. ์˜ค๋ฆ„์ฐจ์ˆœ์œผ๋กœ ์„ ํƒ๋œ ํ–‰ ์ •๋ ฌํ•ด์„œ ๋ณด๊ธฐ SELECT & WHERE & ORDER BY __ DESC; 

 

8-4. ์ œํ•œ๋œ ๊ฐฏ์ˆ˜๋งŒํผ์˜ ์ž๋ฃŒ ํ™•์ธํ•˜๊ธฐ

 

+ ํ…Œ์ด๋ธ” ๋ช… ๋ฐ”๊พธ๊ธฐ

 

9. ์‚ญ์ œํ•˜๊ธฐ

728x90
๋ฐ˜์‘ํ˜•