Temp Tables in MySQL | Advanced MySQL Series

In this lesson we are going to take a look at Temp Tables in MySQL!

____________________________________________

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:

Udemy Courses:

*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!

____________________________________________

Websites:
📱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*

[BruceBeck-fn]

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 😎

[sols]

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 :)

[Simulyasiya]

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

[olirob]

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!

[kyleroutledge]

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

[momohtimothy]

Alex my Mentor from afar. Great video as always!

[remidee]

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.

[witty.coder]

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 ☺️☺️

[aygunsadig]

Hi Alex, in 2:00 i got this Error Code: 1050. Table 'temp_table' already exists response. idk why because i haven't this table before! I just change name like tempt_table then it works as yours, but i wan't to learn why i get this error?

[Successful_AI]

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

[darwinrojas]

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

[gaborhadhazy]

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?

[tonybruce]

Great Alex !

Do you have any videos on writing sql queries on databases in different servers ?

Woukd love to see that

[Trep-AI]

Sorry, when is your Tableau course release data?

[arijitaroy]

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.

[alexandrosvezyropoulos]

is there a lesson for table creation? cant find it

[vaishalitandon]

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

[makarsh]

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

[Amakuru_agezweho]

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

[akmalsayeed]

my output shows same value 3 times. why