MySQL实践
第1章SQL데이터
201007
SELECT * FROM copang_main . member ; -- copang_main이라는 db의 member table을 가져온다.
DATETIME에
年
月
DAYOFMONTH
DATEDIFF
训练
DATE_ADD
DATE_SUB
UNIX_TIMESTAMP
FROM_UNIXTIME
SELECT * FROM member WHERE YEAR(birthday) = ' 1992 ' ;
SELECT * FROM member WHERE MONTH(sign_up_day) IN ( 1 , 2 , 3 );
SELECT * FROM member WHERE DAYOFMONTH(sign_up_day) BETWEEN 16 AND 31 ;
-- = 등호는 그
