Temp Tables in MySQL | Advanced MySQL Series

Поділитися
Вставка
  • Опубліковано 26 вер 2024
  • Full MySQL Course: www.analystbui...
    In this lesson we are going to take a look at Temp Tables in MySQL!
    GitHub Code: github.com/Ale...
    ____________________________________________
    SUBSCRIBE!
    Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
    ____________________________________________
    RESOURCES:
    Coursera Courses:
    📖Google Data Analyst Certification: coursera.pxf.i...
    📖Data Analysis with Python - coursera.pxf.i...
    📖IBM Data Analysis Specialization - coursera.pxf.i...
    📖Tableau Data Visualization - coursera.pxf.i...
    Udemy Courses:
    📖Python for Data Science - bit.ly/3Z4A5K6
    📖Statistics for Data Science - bit.ly/37jqDbq
    📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
    📖Tableau A-Z - bit.ly/385lYvN
    Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
    ____________________________________________
    BECOME A MEMBER -
    Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
    / @alextheanalyst
    ____________________________________________
    Websites:
    💻Website: AlexTheAnalyst.com
    💾GitHub: github.com/Ale...
    📱Instagram: @Alex_The_Analyst
    ____________________________________________
    All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

КОМЕНТАРІ • 40

  • @Simulyasiya
    @Simulyasiya 3 місяці тому +9

    Lord of the Rings is definitely Alex's favourite film trilogy.

  • @sols9019
    @sols9019 6 місяців тому +5

    Hey Guys! Learning from Alex's Bootcamp Playlist this past few days already and really enjoying it! Discussions are so connected, clear and easy to understand. You wont feel like your jumping into different infos (that thought of "huh? what was that? Where did it came from?" feeling. Lol). Not to mention that I don't have any experience of coding or using aggregate functions before :)

    • @TheReditguy
      @TheReditguy 3 місяці тому

      how are you guys doing?

  • @olirob7706
    @olirob7706 4 місяці тому

    You have good movie taste. Lord of the rings the two towers is def one of my fav movies all time. Thank you for the bootcamp!

  • @kyleroutledge470
    @kyleroutledge470 5 місяців тому +6

    Loving the videos Alex, the LotR reference was great! 😂 cracked me up!

  • @momohtimothy6898
    @momohtimothy6898 4 місяці тому +1

    Alex my Mentor from afar. Great video as always!

  • @BruceBeck-f1n
    @BruceBeck-f1n 4 місяці тому +15

    Good Evening Alex, back at it again tonight. Temp Tables in MySQL has been as instructive and as enjoyable as all of the other videos in the series. Again, I'm really grateful (all "thumbs up" have been mashed throughout the course) to have all of this valuable knowledge in one spot. Jim Kwik says "Knowledge isn't power, it is potential power. What we do with the knowledge is the power." Hoping to use your concepts at work to apply the power of your courses. Thanks for all of your time and effort. Cheers! BB 😎

    • @TheReditguy
      @TheReditguy 3 місяці тому

      how are you guys doing?

  • @Successful_AI
    @Successful_AI 2 місяці тому

    @Alex thanks for supporting LOTR The Two Towers! It's also my favourite part and for some reasons it's so underrated

  • @witty.coder1
    @witty.coder1 6 місяців тому

    Hi sir
    I am inspired by you and have created my own channel. I saw your video “Why not to create yt Video” Thanks for such inspiration ☺️☺️

  • @remidee
    @remidee Місяць тому +4

    I've always appreciated Alex the Analyst, but after i watched this video and realized his favourite movie is Lord of The Rings, he has earned much more of my respect. Lol.

  • @yusufbas035
    @yusufbas035 6 місяців тому +1

    Hi alex
    Thanks for the lesson

    • @TheReditguy
      @TheReditguy 3 місяці тому

      how are you guys doing?

  • @makarsh29
    @makarsh29 4 місяці тому

    hey , when you closed the session
    then you have to run :- use database ; command
    then only you can run other queries (although temp table response is as same as u said) but you followed wrong way....
    its always going to show error if you haven't selected (use database command) after closing the session

  • @savannahb5370
    @savannahb5370 6 місяців тому

    Very useful!

  • @vaishalitandon8827
    @vaishalitandon8827 Місяць тому

    Hlo i have created the first temp table and my name last name and movie is showing 4 times in the table
    Can you tell me what is the reason for that

  • @amanibi4596
    @amanibi4596 4 місяці тому +1

    hello guys why I'm always have this error msg for temporary table select *
    from temp_table
    LIMIT 0, 1000 Error Code: 1146. Table 'parks_and_recreation.temp_table' doesn't exist 0.000 sec

    • @sarass9341
      @sarass9341 3 місяці тому

      click on the execution button on the left.

  • @akmalsayeed4595
    @akmalsayeed4595 2 місяці тому +1

    my output shows same value 3 times. why

    • @vaishalitandon8827
      @vaishalitandon8827 Місяць тому

      Mine is showing 4 times
      Did you got the answer of it?

  • @gaborhadhazy6172
    @gaborhadhazy6172 2 місяці тому

    I have noticed that so far you don't really structure the SQL database into folders and files, are there any general folder structures for an SQL project for data analysis, or when you actually work as a data analyst how would you structure your SQL project?

  • @tonybruce6033
    @tonybruce6033 6 місяців тому

    Great Alex !
    Do you have any videos on writing sql queries on databases in different servers ?
    Woukd love to see that

    • @emansabra-n7g
      @emansabra-n7g 2 місяці тому

      There are some playlists for microsoft sql server in alex channel and also some projcts

    • @emansabra-n7g
      @emansabra-n7g 2 місяці тому

      ua-cam.com/play/PLUaB-1hjhk8GT6N5ne2qpf603sF26m2PW.html&si=QMdXGdU2G-ZjVvTS

    • @emansabra-n7g
      @emansabra-n7g 2 місяці тому

      ua-cam.com/play/PLUaB-1hjhk8HTgPnBukmMq7QTe83ANirL.html&si=LGHRpShHCTO9pFP3

    • @emansabra-n7g
      @emansabra-n7g 2 місяці тому

      ua-cam.com/play/PLUaB-1hjhk8EBZNL4nx4Otoa5Wb--rEpU.html&si=KbW8aPzQVqkJLUeH

  • @shivamraina7644
    @shivamraina7644 6 місяців тому

    Hey Alex ! Can u make DIY Data Analyst Curriculum using Udemy for 2024(updated one)

  • @Nour.adel.555
    @Nour.adel.555 3 місяці тому

    Great thanks alot

  • @TrepDolla
    @TrepDolla 6 місяців тому +1

    Sorry, when is your Tableau course release data?

  • @arijitaroy3992
    @arijitaroy3992 Місяць тому

    Hi @Alex, I am getting "Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar." when I am trying to create temp table in mysql. can you pls help me.

    • @Sholzie
      @Sholzie Місяць тому +1

      I presume you're using the second method of creating temp_tables
      Try doing what the error instructs; make the parks and recreation table your default table or indicate which table you're selecting from by writing parks_and_recreation.employee_salary instead of employee_salary used in the video
      I hope this helps😊

    • @halimatlawal8455
      @halimatlawal8455 20 днів тому

      Thank you. This helped me ​@@Sholzie

  • @aakashbhujbal8699
    @aakashbhujbal8699 13 днів тому

    Guys, I think Alex likes Lord of the Rings.

  • @dineshchellaiahc4588
    @dineshchellaiahc4588 5 місяців тому

    Hey Alex, you said , assign the temp table in two types. Until the end, you do not reveal the second type...

    • @KiwinduPeiris
      @KiwinduPeiris 3 місяці тому +3

      Hello, a little late but here is what I understood:
      The first method is to create a TEMPORARY TABLE from scratch, i.e. manually define column names and manually INSERT into the table.
      The second method is to create a TEMPORARY TABLE from another TABLE, i.e. using the SELECT * FROM employee_salary.
      I hope that is what he meant by 'two methods' and I hope my explanation was clear.

  • @AbrarAnnuar
    @AbrarAnnuar 2 місяці тому

    GOLUM GOLUM GOLUM

  • @darwinrojas2208
    @darwinrojas2208 Місяць тому +1

    hello! I did the same exercise but in the end it gave me an error: " Table 'parks_and_recreation.temp_table' doesn't exist" .
    How to know what the error is if I did the same?

    • @juliewali1681
      @juliewali1681 Місяць тому +1

      You need to create the temp table salary_over_50k and once you have the notification that this table was created in the Action Output, you can run the SELECT * FROM salary_over_50k

    • @vaishalitandon8827
      @vaishalitandon8827 Місяць тому

      Same happened with me while creating first temp table exapmle of first name last name and movie