CREATE TEMPORARY TABLE `t1` (`char_utf8_1` CHAR (1) CHARACTER SET utf8,
`c_latin1_1` CHAR (1)
             CHARACTER SET latin1,
`e_utf8`     ENUM ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o',
                   'p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET utf8,
`c_latin1_2` CHAR (1) CHARACTER SET latin1,
`s_utf8_1`   SET  ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o',
                   'p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET utf8,
`e_latin1_1` ENUM ('a','b','c','d','e','f','g','h','i','j','k','l','m','n',
                   'o','p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET latin1,
`s_utf8_2`   SET  ('a','b','c','d','e','f','g','h','i','j','k','l','m','n',
                   'o','p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET utf8,
`c_utf8_2`   CHAR (1) CHARACTER SET utf8,
`s_latin1_1` SET  ('a','b','c','d','e','f','g','h','i','j','k','l','m','n',
                   'o','p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET latin1,
`e_latin1_2` ENUM ('a','b','c','d','e','f','g','h','i','j','k','l','m','n',
                   'o','p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET latin1,
`s_latin1_2` SET  ('a','b','c','d','e','f','g','h','i','j','k','l','m','n',
                   'o','p','q','r','s','t','u','v','w','x','y','z')
             CHARACTER SET latin1);

INSERT IGNORE INTO t1 VALUES  ('f', NULL, 'p', 'h', 'k', NULL, 'b', 'b', 'u', 'k', 'd');
COMMIT;
CREATE TEMPORARY TABLE my_table AS
SELECT * FROM (SELECT * FROM `t1`) AS my_tab1 PROCEDURE ANALYSE(10, 2000);