get from INFORMATION_SCHEMA original SQL code creating VIEW

CREATE TABLE `test` (

  `a` MEDIUMTEXT,

  `b` MEDIUMTEXT

) ENGINE=MYISAM DEFAULT CHARSET=utf8;

CREATE VIEW `view_test` AS

(SELECT * FROM test);

SELECT  `TABLE_NAME`

	,`TABLE_NAME`

	,`VIEW_DEFINITION`

FROM `information_schema`.`VIEWS` IS_V

	WHERE IS_V.`TABLE_SCHEMA`='test' AND IS_V.table_name = 'view_test'

TABLE_NAME  TABLE_NAME  VIEW_DEFINITION                                                                

----------  ----------  -------------------------------------------------------------------------------

view_test   view_test   (SELECT `test`.`test`.`a` AS `a`,`test`.`test`.`b` AS `b` FROM `test`.`test`)

SHOW CREATE VIEW `view_test`

VIEW       CREATE VIEW                                                                                                                                              character_set_client  collation_connection  

---------  -------------------------------------------------------------------------------------------------------------------------------------------------------  --------------------  ----------------------

view_test  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_test` AS (SELECT `test`.`a` AS `a`,`test`.`b` AS `b` FROM `test`)  utf8                  utf8_general_ci