-- 创建视图, sql 语句加了括号, 报错。
CREATE VIEW view_test
AS
(
SELECT * FROM A
UNION ALL
SELECT * FROM B
);
-- 创建视图, sql 语句不加括号, 通过。
CREATE VIEW view_test
AS
SELECT * FROM A
UNION ALL
SELECT * FROM B
-- 创建视图, sql 语句加了括号, 报错。
CREATE VIEW view_test
AS
(
SELECT * FROM A
UNION ALL
SELECT * FROM B
);
-- 创建视图, sql 语句不加括号, 通过。
CREATE VIEW view_test
AS
SELECT * FROM A
UNION ALL
SELECT * FROM B