http://t.zoukankan.com/jeffen-p-5998111.html

mysql> select * from test_main;
+----+-------+
| id | value |
+----+-------+
|  1 | ONE   |
|  2 | TWO   |
|  3 | THREE |
+----+-------+
3 rows in set (0.00 sec)
 
mysql> create table test_main2 select * from test_main;
Query OK, 3 rows affected (0.04 sec)
Records: 3  Duplicates: 0  Warnings: 0
 
 
-- 创建视图， sql 语句加了括号， 报错。
CREATE VIEW view_test_main
AS
(
SELECT * FROM test_main
UNION ALL
SELECT * FROM test_main2
);
 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'UNION
 ALL
SELECT * FROM test_main2
)' at line 5
 
 
 
-- 创建视图， sql 语句不加括号， 通过。
mysql> CREATE VIEW view_test_main
    -> AS
    -> SELECT * FROM test_main
    -> UNION ALL
    -> SELECT * FROM test_main2;
Query OK, 0 rows affected (0.01 sec)

CREATE VIEW iplat62.v_esb_menu as 
SELECT concat_ws('_', 'MM', NODE_ENAME)                     id,
			'MM'                                                 app_id,
			NODE_CNAME                                           menu_name,
			concat_ws('_', 'MM', TREE_ENAME)                     parent_id,
			''                                                   remark,
			NODE_SORT_ID + 0                                     'sort',
			'菜单'                                                 type_name,
			DATE_FORMAT(REC_CREATE_TIME, '%Y-%m-%d %H:%i:%s') AS create_time,
			DATE_FORMAT(REC_REVISE_TIME, '%Y-%m-%d %H:%i:%s') AS update_time,
			'0'                                                  del_flag
FROM iplat62.tedpi10 t1
WHERE TREE_ENAME LIKE 'MM%'
UNION
SELECT concat_ws('_', 'MM', NODE_ENAME)                     id,
			'MM'                                                 app_id,
			NODE_CNAME                                           menu_name,
			'-1'                                                 parent_id,
			''                                                   remark,
			NODE_SORT_ID + 0                                     'sort',
			'菜单'                                                 type_name,
			DATE_FORMAT(REC_CREATE_TIME, '%Y-%m-%d %H:%i:%s') AS create_time,
			DATE_FORMAT(REC_REVISE_TIME, '%Y-%m-%d %H:%i:%s') AS update_time,
			'0'                                                  del_flag
FROM iplat62.tedpi10 t2
WHERE NODE_ENAME = 'MM';