Temp Tables in MySQL | Advanced MySQL Series
HTML-код
- Опубликовано: 18 мар 2024
- Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Temp Tables in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
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/AlexTheAnalyst
📱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
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?
Lord of the Rings is definitely Alex's favourite film trilogy.
Alex my Mentor from afar. Great video as always!
Loving the videos Alex, the LotR reference was great! 😂 cracked me up!
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!
Very useful!
Great Alex !
Do you have any videos on writing sql queries on databases in different servers ?
Woukd love to see that
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 ☺️☺️
Hi alex
Thanks for the lesson
how are you guys doing?
Great thanks alot
Sorry, when is your Tableau course release data?
In about 2 weeks
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
Hey Alex ! Can u make DIY Data Analyst Curriculum using Udemy for 2024(updated one)
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.
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.