Select Curdate

데이터베이스 관리 CREATE DATABASE worldpay; CREATE DATABASE IF NOT EXISTS worldpay; DROP DATABASE worldpay; DROP DATABASE IF EXISTS worldpay; USE worldpay; SELECT DATABASE(); worldpay → payments, backend, ecommerce 등 과제 지문에서 지정 테이블 생성/삭제 CREATE TABLE users ( email VARCHAR(100) NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); DROP TABLE 테이블명; DROP TABLE IF EXISTS 테이블명; DROP TABLE IF EXISTS users, orders, products; TRUNCATE TABLE 테이블명; DELETE FROM 테이블명;...

一、MySQL常用日期函数 1.1、获取时间 # 获取当前日期时间 select NOW(); # 2021-04-02 09:25:29 # 获取当前日期 SELECT CURDATE(); # 2021-04-02 # 获取当前时间 SELECT CURTIME(); # 09:26:10 # 对于时间2021-04-02 09:25:29，分别获取其年、月、日、时、分、秒 SELECT EXTRACT(YEAR FROM NOW()); # 2021 SELECT EXTRACT(MONTH FROM NOW()); # 4 SELECT EXTRACT(DAY FROM NOW()); # 2 SELECT EXTRACT(HOUR FROM NOW()); # 9 SELECT EXTRACT(MINUTE FROM NOW()); # 25 SELECT EXTRACT(SECOND FROM NOW()); # 29 # 或者从日期格式字符串中获取 SELECT EXTRACT(SECOND FROM '2021-04-02 10:37:14.123456'); #...