Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
MySQL Database Tutorial – 8 – Sorting Results
Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
48 responses to “MySQL Database Tutorial – 8 – Sorting Results”
I have 15 rows and want to dis[lay them 3 at a time until I have all of them displayed. So there will be 3 displayed then 6 then 9 then 12 then 15. Can Limit be used to do this?
Love your voice, Bucky!!
Lazy bum drop-out names?
1:10
I think Bucky is better at computer languages then the English language…
fully unqualified name. hahaha
its funny when he says "lucky for you, you have been watching my tutorials"
the names are not sorted alphabetically, it is just the state itself
Correct me if Im wrong
Fantastic once again. Thanks.
Bucky Tuna
rather enjoying chocolate milk m actually enjoying comments below :p
btw nice work man (y)
You said it sorts it alphabetically , then went on to say it doesn't sort it alphabetically but numerically, and then went on to say it stores it alphabetically.
Which is it ?? Numerically and alphabetically ??? and when you say "numerically" , what do you mean ???
now buying chocolate milk
The same videos are in Solo Learn app. I guess, first, he had this channel, then decided to turn it into an app. It's actually pretty good.
thanks a ton for this excellent work, you have a great learning experience with your channel
Can you order two columns.
Ex. SELECT name, zip FROM customers ORDER BY name, zip DESC.
Both names and zip to show from high to low.
dude Bucky, fully qualified names are useful when you have the same column name in two tables; they are not fully useless
Hey Bucky, did you take lessons on how to explain stuff? I can't believe you can make it that easy! Keep on bro
can I take a glass of whiskey instead ?
"ascendingly" or in "ascending order" 😉
Thanks
fantastic and terse, love it.
WTF bucky… I was actually drinking chocolate milk whilst watching this… U WIZARD +Bucky Roberts
Man you're tutorials are really Good. And for all of you that has a problem just like Robert thats a normal thing of PHPMYADMIN don't worry
what query chang when order by id
For numbers is … ascending sort 😉
you have to spit to the ground after saying Alabama, the spitting is the most important rule of pronunciating Alabama
nice tuts DUDE )
u are awesome +thenewboston
i love you
Hey there… I get this message and I dpnt't thnik I did something wrong…. Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Can anyone help ?
2 tables could have the same field name, so this is why you would use fully qualified names. Avoiding ambiguous conditions
2:36 – harry potter pmsl
Bucky u deserve a nobel price:)
(AK) "Arkansas" – Bucky
"Bucky, Noah, Kelsey, Corey, Hairy..ukay"
-Bucky Roberts
"Fully unqualified names"
-Bucky Roberts
You are a great teacher, thank you so much 🙂
thanks !
doctor (doctor_name, residence_address, postal_code, year_experience)
works (doctor_name, branch_name, annual_pay)
branch (branch_name, branch_address, postal_code)
patient (patient_name, doctor_name, branch_name)
Produce a query to display the doctor’s name, residence address whose postal code is the same as branch where he works.
Produce a query to increase the salary by 5% for all doctors who work in “Bedok” branch.
PLEASE HELP
Thumbs up for just now going slightly out of your way to get chocolate milk.
Same thing i guess… If you have a ehm… a lastname colum? or something… Then i guess you write… SELECT * FROM customers ORDER BY lastname
what if you wanted to order by last name?
Thank you bucky! You really are a great teacher.
5:24 "Ark-Kansas….I dunno what its called…' HAHA Bucky you're amazing!
@am100669 am i going to be an average DBA after watching all this sql tutorials?
I probably said it on an earlier video, if so, once again, thank you for these tutorials!
I went and got Strawberry milk