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
Lord of the Rings is definitely Alex's favourite film trilogy.
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 :)
how are you guys doing?
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!
Loving the videos Alex, the LotR reference was great! 😂 cracked me up!
Alex my Mentor from afar. Great video as always!
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 😎
how are you guys doing?
@Alex thanks for supporting LOTR The Two Towers! It's also my favourite part and for some reasons it's so underrated
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 ☺️☺️
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.
Hi alex
Thanks for the lesson
how are you guys doing?
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
Very useful!
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
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
click on the execution button on the left.
my output shows same value 3 times. why
Mine is showing 4 times
Did you got the answer of it?
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?
Great Alex !
Do you have any videos on writing sql queries on databases in different servers ?
Woukd love to see that
There are some playlists for microsoft sql server in alex channel and also some projcts
ua-cam.com/play/PLUaB-1hjhk8GT6N5ne2qpf603sF26m2PW.html&si=QMdXGdU2G-ZjVvTS
ua-cam.com/play/PLUaB-1hjhk8HTgPnBukmMq7QTe83ANirL.html&si=LGHRpShHCTO9pFP3
ua-cam.com/play/PLUaB-1hjhk8EBZNL4nx4Otoa5Wb--rEpU.html&si=KbW8aPzQVqkJLUeH
Hey Alex ! Can u make DIY Data Analyst Curriculum using Udemy for 2024(updated one)
Great thanks alot
Sorry, when is your Tableau course release data?
In about 2 weeks
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.
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😊
Thank you. This helped me @@Sholzie
Guys, I think Alex likes Lord of the Rings.
Hey Alex, you said , assign the temp table in two types. Until the end, you do not reveal the second type...
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.
GOLUM GOLUM GOLUM
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?
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
Same happened with me while creating first temp table exapmle of first name last name and movie