22,207
社区成员
发帖
与我相关
我的任务
分享myslq视图里支不支持union
语句为：
CREATE VIEW mainview(ID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
这样写报错！请大侠指点！
CREATE VIEW mainview(ID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
这样写报错！请大侠指点！
...全文
请发表友善的回复…
发表回复
技术first 2012-03-22
- 打赏
- 举报
嘿嘿，我自己已经搞出来了，一楼说的是对的！
开着拖拉机泡妞 2012-03-21
- 打赏
- 举报
[Quote=引用 1 楼 liangck 的回复:]
CREATE VIEW mainview(ID)
AS
SELECT ID FROM student
UNION
SELECT ID FROM teacher;
[/Quote]
CREATE VIEW mainview(ID)
AS
SELECT ID FROM student
UNION
SELECT ID FROM teacher;
[/Quote]
liangCK 2012-03-21
- 打赏
- 举报
CREATE VIEW mainview(ID)
AS
SELECT ID FROM student
UNION
SELECT ID FROM teacher;
AS
SELECT ID FROM student
UNION
SELECT ID FROM teacher;
dawugui 2012-03-21
- 打赏
- 举报
[Quote=引用楼主 sayid_cslg 的回复:]
语句为：
CREATE VIEW mainview(ID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
这样写报错！请大侠指点！
[/Quote]mysql的语法和sql server可能不一样,建议去mysql版问.
语句为：
CREATE VIEW mainview(ID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
这样写报错！请大侠指点！
[/Quote]mysql的语法和sql server可能不一样,建议去mysql版问.
