此错误是由于:
view的select子句中,被union all的第二个select子句的常量空格字段没有指定名称,
手工生成此view时无错误,但是导出此view的create语句时,mysql自动将每个字段默认了名称
CREATE ALGORITHM=UNDEFINED
DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `v_temp` AS select `tb1`.`col1` AS `names` from `tb1` union all select [color=red]'' AS ``[/color] from `tb2`
view的select子句中,被union all的第二个select子句的常量空格字段没有指定名称,
手工生成此view时无错误,但是导出此view的create语句时,mysql自动将每个字段默认了名称
CREATE ALGORITHM=UNDEFINED
DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `v_temp` AS select `tb1`.`col1` AS `names` from `tb1` union all select [color=red]'' AS ``[/color] from `tb2`