blob: 0b4b7da8445cff1fd8cce61a55b69e1ba2112951 (
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=utf8 COLLATE=utf8_general_ci COMMENT='engine "InnoDB"'
DROP TABLE bugs;
|
