【文件属性】:
文件名称:MySQL实践
文件大小:12KB
文件格式:ZIP
更新时间:2021-02-18 06:36:36
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 ;
-- = 등호는 그
【文件预览】:
mySQL-practice-master
----codeit2.sql(1KB)
----codeit.sql(2KB)
----README.md(16KB)
----chapter2.md(10KB)