diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_drop_column.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_drop_column.result | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_drop_column.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_drop_column.result new file mode 100644 index 00000000000..07c149a8fa8 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/alter_table_drop_column.result @@ -0,0 +1,37 @@ +DROP TABLE IF EXISTS diaries; +CREATE TABLE diaries ( +id INT PRIMARY KEY AUTO_INCREMENT, +title TEXT, +body TEXT +) DEFAULT CHARSET UTF8 COMMENT = 'ENGINE "InnoDB"'; +SHOW CREATE TABLE diaries; +Table Create Table +diaries CREATE TABLE `diaries` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text, + `body` text, + PRIMARY KEY (`id`) +) ENGINE=Mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"' +INSERT INTO diaries (title, body) VALUES ("survey", "will start groonga!"); +SELECT * FROM diaries; +id title body +1 survey will start groonga! +ALTER TABLE diaries DROP COLUMN body; +SHOW CREATE TABLE diaries; +Table Create Table +diaries CREATE TABLE `diaries` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text, + PRIMARY KEY (`id`) +) ENGINE=Mroonga AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"' +SELECT * FROM diaries; +id title +1 survey +INSERT INTO diaries (title) values ("groonga (1)"); +INSERT INTO diaries (title) values ("groonga (2)"); +SELECT * FROM diaries; +id title +1 survey +2 groonga (1) +3 groonga (2) +DROP TABLE diaries; |