"Fossies" - the Fresh Open Source Software Archive

Member "mroonga-12.04/mysql-test/mroonga/wrapper/alter_table/r/add_column.result" (6 Jun 2022, 709 Bytes) of package /linux/misc/mroonga-12.04.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 DROP TABLE IF EXISTS diaries;
    2 CREATE TABLE diaries (
    3 id INT PRIMARY KEY AUTO_INCREMENT,
    4 title TEXT
    5 ) DEFAULT CHARSET UTF8MB4 COMMENT = 'ENGINE "InnoDB"';
    6 INSERT INTO diaries (title) VALUES ("survey");
    7 SELECT * FROM diaries;
    8 id	title
    9 1	survey
   10 ALTER TABLE diaries ADD COLUMN body TEXT;
   11 UPDATE diaries SET body = "will start groonga!";
   12 SELECT * FROM diaries;
   13 id	title	body
   14 1	survey	will start groonga!
   15 INSERT INTO diaries (title, body) values ("groonga (1)", "starting groonga...");
   16 INSERT INTO diaries (title, body) values ("groonga (2)", "started groonga.");
   17 SELECT * FROM diaries;
   18 id	title	body
   19 1	survey	will start groonga!
   20 2	groonga (1)	starting groonga...
   21 3	groonga (2)	started groonga.
   22 DROP TABLE diaries;