MySQL Forums
Forum List  »  General

Re: MySQL Parenthesis Question
Posted by: Sushant Choudhary
Date: October 03, 2017 11:27AM

Can I ask you question here regarding Union since no body has answered this question on forum??

does mysql offer guarantees on the order of the results from a UNION query? if it does is it written in mysql documentation??

example:

`select col1 from table1 union select col2 from table2;`

if above is my query. does result will contain the data from table1 followed by result from table2.

if table1 has data for 1, 4 . and table2 has data 2, 3

the result will be 1, 4, 2, 3 or 2, 3, 1, 4 ??

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
October 02, 2017 12:38PM
Re: MySQL Parenthesis Question
October 03, 2017 11:27AM


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.