blob: 341cc4f7de7d05122f8dc65b22b921e7b434a075 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
DROP TABLE IF EXISTS memos;
CREATE TABLE IF NOT EXISTS memos (
id VARCHAR(45) NOT NULL PRIMARY KEY,
text TEXT NOT NULL,
FULLTEXT KEY (text)
) DEFAULT CHARSET=utf8 COMMENT='engine "InnoDB"';
LOCK TABLES memos WRITE;
ALTER TABLE memos DISABLE KEYS;
INSERT INTO memos
VALUES (00000, 'text0'),
(00001, 'text1'),
(00002, 'text2');
ALTER TABLE memos ENABLE KEYS;
UNLOCK TABLES;
SELECT * FROM memos;
id text
0 text0
1 text1
2 text2
DROP TABLE memos;
|
