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
MySQL Database Tutorial – 11 – Advanced Filtering Using AND and OR
36 responses to “MySQL Database Tutorial – 11 – Advanced Filtering Using AND and OR”
0:07 – using "n" keyword? That was inappropriate, young man!
thanks bucky
So basically..
Well basically..
And basically..
Oh my gosh Bucky you are so cute!! Please keep making such wonderfully amazing tutorials!
RIP to all three of dislikers, may god bless your souls.
I watched Your all video ,jAva,C and etc it was awesome..But please upload video for how to create Table..
which software you use to record and zoom while typing.
now i m getting You 🙂 awsm
Can you do a Selenium tutorial?
VERY GOOD. I LIKE IT.THANKS
subsribe back plzzz
There's a Hollywood in Florida.
Put the speed on 1.5 to learn faster.
Jack Nicholson lmfao, scared the shit outta me.
Just wanted to ask. if we have multiple costumers that has a id of 1 and 2. for example we have 5costumers that has a id no of 1, and 4 costumers of an id no of 2.
Does, SELECT id, name, city FROM costumers WHERE id=1 OR id=2 AND city="Raleigh"
will it show all costumers with an id no of 1 and 2.
Its like, SELECT id, name, city FROM costumers WHERE id=1 OR id=2
to make it clear.
What if there is no costumer with an id no of 1 and 2 that lives in Raleigh, will it give the same result?
in SELECT id, name, city FROM costumers WHERE id=1 OR id=2 AND city="Raleigh"
There is no difference between OR and ||,AND and &&
just to make it a little bit more clear. OR is a logical operation that stands for sum, AND is a logical operation which stands for multiplication. From math we know, that we do multiplication before sum. So in case we want to change this, we use parenthesis, simple math.
I go through a 50 min lecture and i don't understand shit plus I pay heaps. I watch a few of these short videos and I understand everything. 😛
Damn true
booleans! 😀
great teacher!!!
Without you many people would get fires 😀
bucky, THANK YOU! Your tutorials are awesome
Everyone says how bad schools and teachers are and how good these free tutorials are–and I agree! However, I want to make sure that all these people, if ever they become employers, remember this sentiment and NOT REQUIRE DEGREES FROM PROSPECTIVE EMPLOYEES! Deal? 🙂
@suicidebombadil This is the main reason why i staryed to study on my own. the only reason that i havent dropped out of college just like Bucky did is ecause in my country you cannot have a good salary if dont have a career. so yeah,i go to college just becaus i need that goddamn paper.
Just to clarify things, this happens because logical AND comes above logical OR in the order of precedence. Hopefully that should help when you have to decide whether to use brackets or not.
What if I want to search people in 50% of the states, how do I shorten that?
Love you so much, thanks for the lesson
in playlist
Hollywood, FL
where is 10th vid…thank you so much Bucky you are the best I am learning much from u may God give you a long life.GBU
thank u
I think its
((((1 AND 0) OR 0) OR 1) AND 1)
wat?
3 OR 3 = 3
3 AND 3 = 3
Used a scientific calculator e_e
10 in binary = 2 in decimal and yes 1 and 0 = 0 because if you say and is multiplication than 1×0=0 and he rest are right
no its in binary math and electronics so if you have an or gate and you input 1 and 0 to it it will give you 1 because 1+0=1 but it wont work if you give it 1 + 1 because it cant give you 10 for that it needs a carrier that is why I said its kinda like adding and multiplying because you need carriers to make it a true addition or a true multiplication
I know me too but calling them operators is from the mathematical side of the story not the coding side
lol its funny how before you said they aren't operators