blob: f1532a14c21d81e4471f902df96709ead06ec7ef (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
DROP TABLE IF EXISTS bugs;
CREATE TABLE bugs (
id INT UNSIGNED PRIMARY KEY,
tag VARCHAR(64)
) DEFAULT CHARSET=utf8 COMMENT='engine "InnoDB"';
ALTER TABLE bugs
CHANGE COLUMN
tag
tag VARCHAR(64) COMMENT 'It must consist of only alphabet and number.';
SHOW CREATE TABLE bugs;
Table Create Table
bugs CREATE TABLE `bugs` (
`id` int(10) unsigned NOT NULL,
`tag` varchar(64) DEFAULT NULL COMMENT 'It must consist of only alphabet and number.',
PRIMARY KEY (`id`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3 COMMENT='engine "InnoDB"'
DROP TABLE bugs;
|