blob: f85e84121df080edfdbf7387b6f5dd3dc29034f7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
DROP TABLE IF EXISTS ids;
CREATE TABLE ids (
id INT NOT NULL
) ENGINE=Mroonga DEFAULT CHARSET=utf8;
INSERT INTO ids VALUES (1);
INSERT INTO ids VALUES (2);
ALTER TABLE ids ADD PRIMARY KEY (id);
SHOW CREATE TABLE ids;
Table Create Table
ids CREATE TABLE `ids` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
SELECT * FROM ids WHERE id = 2;
id
2
DROP TABLE ids;
|
