Re: MySQL Parenthesis Question
I have mysql community edition 5.7.12. in that release it does not support.
I have same problem with union clause too.
1. (select db from servers) union (select user from user) # suport
2. (select db from servers union select user from user) . # does not support
3. select * from (select db from servers union select user from user) # support
all the 3 will produce same result. Then why mysql does not support #2 case.
Subject
Written By
Posted
September 21, 2017 12:35PM
September 21, 2017 12:46PM
September 21, 2017 01:09PM
September 21, 2017 01:51PM
September 22, 2017 02:47AM
Re: MySQL Parenthesis Question
October 02, 2017 11:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.