MYSQL 创建临时视图表

-- 创建视图

CREATE
    ALGORITHM = UNDEFINED
    DEFINER = `root`@`%`
    SQL SECURITY DEFINER
    VIEW `year_month_view` AS
    SELECT '香蕉' AS `水果`
    UNION SELECT '苹果' AS `水果`
    UNION SELECT '桃子' AS `水果`

-- 删除视图
     drop view year_month_view