• Wednesday , 13 December 2017

MySQL Database Tutorial – 8 – Sorting Results

Code Canyon



Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …

Original source

3d Ocean

Related Posts

48 Comments

  1. Reginald Savage
    September 14, 2017 at 18:17

    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?

  2. Capt. Fantastic
    September 14, 2017 at 18:17

    Love your voice, Bucky!!

  3. A Kane
    September 14, 2017 at 18:17

    Lazy bum drop-out names?

  4. AJay Gupta
    September 14, 2017 at 18:17

    1:10

  5. Andrewboy159
    September 14, 2017 at 18:17

    I think Bucky is better at computer languages then the English language…

  6. Chuck Baby
    September 14, 2017 at 18:17

    fully unqualified name. hahaha

  7. Kashish Shah
    September 14, 2017 at 18:17

    its funny when he says "lucky for you, you have been watching my tutorials"

  8. ronnel rodriguez
    September 14, 2017 at 18:17

    the names are not sorted alphabetically, it is just the state itself
    Correct me if Im wrong

  9. CobraL0rd
    September 14, 2017 at 18:17

    Fantastic once again. Thanks.

  10. Tips and Tricks
    September 14, 2017 at 18:17

    Bucky Tuna

  11. mariam shaikh
    September 14, 2017 at 18:17

    rather enjoying chocolate milk m actually enjoying comments below :p
    btw nice work man (y)

  12. Computer Science
    September 14, 2017 at 18:17

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

  13. David
    September 14, 2017 at 18:17

    now buying chocolate milk

  14. Maria Concepcion
    September 14, 2017 at 18:17

    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.

  15. Atul Chavan
    September 14, 2017 at 18:17

    thanks a ton for this excellent work, you have a great learning experience with your channel

  16. PCMATE - HOW TO
    September 14, 2017 at 18:17

    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.

  17. Ali Kasem
    September 14, 2017 at 18:17

    dude Bucky, fully qualified names are useful when you have the same column name in two tables; they are not fully useless

  18. Il Pella
    September 14, 2017 at 18:17

    Hey Bucky, did you take lessons on how to explain stuff? I can't believe you can make it that easy! Keep on bro

  19. xXKYKYXx99
    September 14, 2017 at 18:17

    can I take a glass of whiskey instead ?

  20. candh
    September 14, 2017 at 18:17

    "ascendingly" or in "ascending order" 😉

  21. Husain Ahmmed
    September 14, 2017 at 18:17

    Thanks

  22. Atlas Wlk
    September 14, 2017 at 18:17

    fantastic and terse, love it.

  23. SirJammy ASMR
    September 14, 2017 at 18:17

    WTF bucky… I was actually drinking chocolate milk whilst watching this… U WIZARD +Bucky Roberts

  24. Luis Carlos
    September 14, 2017 at 18:17

    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

  25. Majestic Barrack
    September 14, 2017 at 18:17

    what query chang when order by id 

  26. Pace Adrian
    September 14, 2017 at 18:17

    For numbers is … ascending sort 😉

  27. straight white anglo-saxon protestant man
    September 14, 2017 at 18:17

    you have to spit to the ground after saying Alabama, the spitting is the most important rule of pronunciating Alabama

  28. 33t00p
    September 14, 2017 at 18:17

    nice tuts DUDE )

  29. Nikolai O. E
    September 14, 2017 at 18:17

    u are awesome +thenewboston 

  30. Mike De Llano
    September 14, 2017 at 18:17

    i love you

  31. Robert Minea
    September 14, 2017 at 18:17

     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 ? 

  32. Paul Brown
    September 14, 2017 at 18:17

    2 tables could have the same field name, so this is why you would use fully qualified names. Avoiding ambiguous conditions

  33. Void
    September 14, 2017 at 18:17

    2:36 – harry potter pmsl

  34. Redi Pg
    September 14, 2017 at 18:17

    Bucky u deserve a nobel price:)

  35. Ferris876
    September 14, 2017 at 18:17

    (AK) "Arkansas" – Bucky

  36. mohamed ahmed
    September 14, 2017 at 18:17

    "Bucky, Noah, Kelsey, Corey, Hairy..ukay"
    -Bucky Roberts

  37. Nugenrules
    September 14, 2017 at 18:17

    "Fully unqualified names"
    -Bucky Roberts

  38. Araam Mamali
    September 14, 2017 at 18:17

    You are a great teacher, thank you so much 🙂

  39. Razvan Ghena
    September 14, 2017 at 18:17

    thanks !

  40. Joleen Tan
    September 14, 2017 at 18:17

    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

  41. Otto Cortes
    September 14, 2017 at 18:17

    Thumbs up for just now going slightly out of your way to get chocolate milk.

  42. movie627
    September 14, 2017 at 18:17

    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

  43. Cheyenne Shadanbaz
    September 14, 2017 at 18:17

    what if you wanted to order by last name?

  44. Robert Wong
    September 14, 2017 at 18:17

    Thank you bucky! You really are a great teacher.

  45. Beth G
    September 14, 2017 at 18:17

    5:24 "Ark-Kansas….I dunno what its called…' HAHA Bucky you're amazing!

  46. ChrisPTY507
    September 14, 2017 at 18:17

    @am100669 am i going to be an average DBA after watching all this sql tutorials?

  47. cubiemuncherr
    September 14, 2017 at 18:17

    I probably said it on an earlier video, if so, once again, thank you for these tutorials!

  48. Adrian Marshall
    September 14, 2017 at 18:17

    I went and got Strawberry milk

Leave A Comment

You must be logged in to post a comment.