MySQL Forums
Forum List  »  General

Re: MySQL Parenthesis Question
Posted by: Gleb Shchepa
Date: October 02, 2017 12:38PM

Hello Sushant,

MySQL supports #2 since 8.0.0.

-------------------------------------------------------
> 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.

Gleb Shchepa,
Senior Software Developer,
MySQL Group, Oracle

"The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation."

Options: ReplyQuote


Subject
Written By
Posted
September 21, 2017 12:35PM
September 21, 2017 12:46PM
September 21, 2017 01:51PM
September 22, 2017 02:47AM
Re: MySQL Parenthesis Question
October 02, 2017 12:38PM


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.