blob: 8a45ece7813f1b1e37f49ed4ca6178fd07afaf60 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
created_at DATETIME
) DEFAULT CHARSET UTF8;
INSERT INTO diaries (title, created_at)
VALUES ("clear day", "2012-01-29 21:51:01");
INSERT INTO diaries (title, created_at)
VALUES ("rainy day", "2012-01-30 01:23:45");
INSERT INTO diaries (title, created_at)
VALUES ("cloudy day", "2012-01-31 08:32:10");
SELECT * FROM diaries;
id title created_at
1 clear day 2012-01-29 21:51:01
2 rainy day 2012-01-30 01:23:45
3 cloudy day 2012-01-31 08:32:10
SELECT * FROM diaries
WHERE created_at BETWEEN "2012-01-29 00:00:00" AND "2012-01-31 00:00:00";
id title created_at
1 clear day 2012-01-29 21:51:01
2 rainy day 2012-01-30 01:23:45
DROP TABLE diaries;
|