blob: 2be9834c61778d2c6279ce3f07aa590280b95afb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT
) DEFAULT CHARSET UTF8 COMMENT = 'ENGINE "InnoDB"';
INSERT INTO diaries (title) VALUES ("survey");
SELECT * FROM diaries;
id title
1 survey
ALTER TABLE diaries ADD COLUMN body TEXT;
UPDATE diaries SET body = "will start groonga!";
SELECT * FROM diaries;
id title body
1 survey will start groonga!
INSERT INTO diaries (title, body) values ("groonga (1)", "starting groonga...");
INSERT INTO diaries (title, body) values ("groonga (2)", "started groonga.");
SELECT * FROM diaries;
id title body
1 survey will start groonga!
2 groonga (1) starting groonga...
3 groonga (2) started groonga.
DROP TABLE diaries;
|