Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ – https://plus.google.com/+BuckyRoberts LinkedIn – https://www.linkedin.com/in/buc…
Original source
Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ – https://plus.google.com/+BuckyRoberts LinkedIn – https://www.linkedin.com/in/buc…
Original source
26 responses to “MySQL Database Tutorial – 24 – UNION”
Thank you so much <3.
Concatenation Operator
I was having trouble with my semester but these lectures save me
what is going on guys lol !
Once again,, Bucky to the rescue. You the best man,,
What to use if column names are different for different tables?
Cant we use OR Instead UNION to get same result?
Can't I just use a sub query to accomplish the same task as a union? Is there some advantages to using Union instead of a subquery?
Your videos are amazing! Thank you so much! Do you know why the transcripts don't match up to exactly what you say as i like to take notes on your tutorials?
@Herp Derpingson
You can do it with php by conecting you're database and than typing in:
$_query="SELECT name,id FROM customers WHERE id>=10 OR LIKE 'a%s' ''
For example.Hope I helped you.
I only get Baby seat once even when using Union ALL
why does it show items with costs lower than 1000 when your query states only items greater than 1000?
Months I've been researching and putting the data into spreadsheets, thinking one day this information will become useful to me. Conceptually that day has arrived and my brain nearly just exploded with possibility after watching this video. Cooool.
if you are so so smart "azn1viet", why are you watching the tutorials. why dont you stfu.
these BOSS examples are really effective in learning
We can only hope.
Youtube filtered my "greater than sign"…
This is not true from ur result with the belt bids = 4: like others said, UNION is an OR operation. You can do this …. WHERE (bids100 AND cost 1000)…
UNION just doing an OR operation…
if alteast one condition true, it simply returns..
bucky u can't use this item for sorting items like shopping websites…
because UNION doing OR operation…
it will not satisfy both condition always..
A where clause won't do any w- something
There was a part where he kinda became unclear and I have no idea what he said. It was towards the end of the video. Can someone explain what he was saying
You forgot to mention that UNION is interpreted by MYSQL an OR statement,so thats why using UNION ALL shows the duplicate columns if a column were to "accomplish" 2 or more select statements.
Very good tuts, keep up the good work!
or even CNN HEROES
than u
How do I join SQL tables with PHP or javascript?