MySQL Database Tutorial – 32 – Views




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

Original source


45 responses to “MySQL Database Tutorial – 32 – Views”

  1. I really enjoyed this video, it taught me something new that I can really use for my project. Your videos seem to be the only ones here on YouTube that have some quality to it. There's one that I miss in your playlist: triggers. I don't know if you cover that subject in a different video, but I really don't have the time to sift through 33 videos 🙂

  2. View seems really helpful!!
    To previous sub-query video:

    CREATE VIEW sel AS SELECT * FROM items WHERE name REGEXP('frogs')
    SELECT * FROM sel WHERE cost = (SELECT min(cost) FROM sel)

    step 1: narrow down to a view of sellers who sell frogs
    step 2: get related information with min(cost) from that view

Leave a Reply