blob: 439684ac5d61c87d8985383ed63970f6fd5de5d3 (
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
SELECT * FROM ids WHERE id = 2;
id
2
DROP TABLE ids;
|
