blob: c5764cc110cf9f02ce691926e9a116f7f3ce7b6d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
created_at DATETIME
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE diaries;
Table Create Table
diaries CREATE TABLE `diaries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8
INSERT INTO diaries (title, created_at)
VALUES ('2038-01-18 03:14:07', '2038-01-18 03:14:07');
INSERT IGNORE INTO diaries (title, created_at)
VALUES ('2038-01-20 03:14:08', '2038-01-20 03:14:08');
Warnings:
Warning 1265 Data truncated for column 'created_at' at row 1
SELECT * FROM diaries;
id title created_at
1 2038-01-18 03:14:07 2038-01-18 03:14:07
2 2038-01-20 03:14:08 1970-01-01 00:00:00
DROP TABLE diaries;
|