MySQL实践

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 ; -- = 등호는 그