blob: 1825ee5bbed3adcd8084671e9370de43324f1157 (
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
26
27
28
|
DROP TABLE IF EXISTS tags, bugs;
CREATE TABLE tags (
name VARCHAR(64) PRIMARY KEY
) DEFAULT CHARSET=utf8
COLLATE=utf8_bin
COMMENT='default_tokenizer "TokenDelimit"';
CREATE TABLE bugs (
id INT UNSIGNED PRIMARY KEY,
tags VARCHAR(128) DEFAULT '' COMMENT 'flags "COLUMN_VECTOR", type "tags"'
) DEFAULT CHARSET=utf8;
SHOW CREATE TABLE bugs;
Table Create Table
bugs CREATE TABLE `bugs` (
`id` int(10) unsigned NOT NULL,
`tags` varchar(128) DEFAULT '' COMMENT 'flags "COLUMN_VECTOR", type "tags"',
PRIMARY KEY (`id`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3
INSERT INTO bugs (id, tags) VALUES (1, "Linux MySQL groonga");
SELECT * FROM bugs;
id tags
1 Linux MySQL groonga
SELECT * FROM tags;
name
Linux
MySQL
groonga
DROP TABLE bugs;
DROP TABLE tags;
|