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

๐Ÿ’ป Deep Wide Programming/Mysql & Database

[์ƒํ™œ์ฝ”๋”ฉ] MySQL SELECT Syntax

728x90
๋ฐ˜์‘ํ˜•

ํŠน์ • Column ๊ฐ’๋งŒ ๋ณด๊ณ  ์‹ถ์„ ๋•Œ, 

์ด๋ ‡๊ฒŒ ๋ชจ๋“  ํ‘œ๊ฐ€ ์•„๋‹ˆ๋ผ, ํ‘œ ์ค‘์—์„œ๋„ id, title, created, authour์— ๋Œ€ํ•œ ๊ฐ’๋งŒ ๋ณด๊ณ ์‹ถ์„๋•Œ๋Š” '

SELECT ๊ณผ From ํ…Œ์ด๋ธ”์ด๋ฆ„ ์‚ฌ์ด์— ํ•ด๋‹น ์—ด ์ด๋ฆ„์„ ๋„ฃ์–ด์ค€๋‹ค.


 

ํŠน์ • Row ๊ฐ’์— ๋Œ€ํ•œ ์ •๋ณด๋งŒ ๋ณด๊ณ  ์‹ถ์„ ๋•Œ, [Where]

 

์ด๋ ‡๊ฒŒ authour๊ฐ€ egoing์ธ ๊ฐ’์— ๋Œ€ํ•ด์„œ๋งŒ ๋ณด๊ณ ์‹ถ์„ ๋•Œ๋Š”, 

from topic ๋’ค์— "WHERE"๋ฌธ์„ ์ถ”๊ฐ€ํ•œ๋‹ค. '


ํŠน์ • ์—ด์˜ ๋‚ด๋ฆผ์ฐจ์ˆœ์œผ๋กœ ๋ณด๊ณ ์‹ถ์„ ๋•Œ, [ORDER BY id DESSC]


ํŠน์ • ๊ฐฏ์ˆ˜๊นŒ์ง€๋งŒ ๋ณด๊ณ ์‹ถ์„ ๋•Œ, [DESC LIMIT]

 

 


DATABASE๋ฅผ ์ž˜ํ•œ๋‹ค์˜ ํ•ต์‹ฌ์€, ํ•„์š”์— ๋”ฐ๋ผ ์ด SELECT๋ฌธ์„ ์ž˜ ์‚ฌ์šฉํ•œ๋‹ค๋Š” ๊ฒƒ์— ์žˆ๋‹ค.

728x90
๋ฐ˜์‘ํ˜•