我创建一个视图,在视图里用union怎么报错啊!语句为:
CREATE VIEW mainview(MID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
错误信息为: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
(SELECT ID FROM teacher))' at line 4student.ID和teacher.ID 没问题的。这是什么情况啊!我mysql服务器是:mysql-connector-net-6.4.4.msi!
请大侠们帮忙啊!
CREATE VIEW mainview(MID)
AS
((SELECT ID FROM student)
UNION (SELECT ID FROM teacher));
错误信息为: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
(SELECT ID FROM teacher))' at line 4student.ID和teacher.ID 没问题的。这是什么情况啊!我mysql服务器是:mysql-connector-net-6.4.4.msi!
请大侠们帮忙啊!
解决方案 »
- 我的mysql里面怎么没有mysqldumpslow命令,只是在script文件夹下有个mysqldumpslow,和mysqldumpslow.sh
- 安装HandlerSocket,with-mysql-source报错,如何解决?
- 请问我的设置的索引有问题吗
- 求助, MYSQL 合并更新问题
- mysql合并数据库问题
- 向左左提问:MYSQL参数设定
- mysql 导入问题
- 登录tomcat时出错,请高手帮我看下。急!!!
- 请问怎样删除重复数据?
- 请通过这个例子简要解释一下*.sql文件的语法
- mysql的从另外一张表update多个字段语句如何优化
- group前需取得倒序数据,有什么好方法吗?
as
select SELECT ID FROM student
union
SELECT ID FROM teacher
Query OK, 0 rows affected (0.05 sec)
在5.5.32中没有问题