Python and MySQL - Creating our Database and Table

A series of Python Tutorials covering all the basics of Python and MySQL. This video will cover learning how to create our own database with Python and then create our first table inside the database.

♦♦♦♦♦♦♦♦♦♦

THECODEX is a company focused on empowering and enabling anyone to learn how to code. Established in 2015 by Avinash Jain, THECODEX has taught over 175,000 students around the world how to code. With over 15 programming courses on a wide variety of topics, and more than 10,000 5-Star reviews, THECODEX is the right choice for you.

We provide engaging and comprehensive videos that break down complex information and cover everything you need to know about the subject. All students get access to our Q/A forums where you can get your doubts and problems cleared up. At the end of every course, you will receive a certificate of completion.

Jumpstart your Coding Journey with THECODEX today!

♦♦♦♦♦♦♦♦♦♦

Music: Flash Funk (Marshmello)

[liampilarski]

wth how is this guy so so so so so much better than any other sql tutorial on internet could have saved 3 hours if i found him first

[elkhanhamet]

Thank you very much guy. Incredible tutorial. pip install mysqlclient kept giving me an error for almost a week now. And this worked!!! Thanks again

[wort]

Exactly what i needed, and it's on point.

Thanks so much

[tobz]

Perfect explanation and execution. Many thanks.

[nicksparks]

Great so far, a little tricky at first - which is ok - a bit of a jiggle in workbench and pycharm but brill to get something like this actually working.

[venkatesh]

good job man. I am following you in all sites. It's really great series. Please continue.

[pratibhasinha]

This working Can't thank you enough for

[darktarget]

how can you have just 38k views with such and amazing course?... i'm going to tell my friends to come!. Thank you for sharing your knowledge, btw.

[trouserpython]

Ohh this guy is good, this guy is very good

[TheZinho]

This was going wrogn for me because the mysql dialect was not selected. I just had to change that on "Settings" and everything worked fine. Thanks for the video!!

[mitentallewar]

this video and previous one also helpful.... looking for the next one
thanks

[kevinlao]

Just in case someone else hits the exact same problem as I did, if you hit an error that looks like:
"Authentication plugin 'caching_sha2_password' is not supported"

Solution:
Instead of using mysql-connector, use mysql-connector-python.

Source:

[klzntek]

This is exactly what I was looking for. Thank you so much.

[pecmpru]

do we have to specify host, user and password every time we connect to the database?

[ayaneshsarkar]

You should be having more subscribes, good presentation!

[wilebaldoalvarez]

Hi, I have a question. I have plans to do some apps to practice or show what I can do, this apps is about to inventory control, warehouse management and/or point of sale. Before I did some similar but in small scale with excel or in FileMaker, but now I want to do it something more seriously and if is posible multiplatform, i'm working on Mac same as you, but I'm not sure if do it this as a webapp with Java and sql or do it with python or any other programing language as native app in the different platforms.

What did you recommend to me? work as webapp or native apps and in what programing language?

[Vishu]

3680 (HY000): Failed to create schema directory 'NEWBANK' (errno: 2 - No such file or directory)
PLEASE HELP !!!!

[renancatan]

Very nice! Mysql community version is free, right? Do you know how much space can I use?

Another question, I saw that youre importing your connection from a local server, is it really on the cloud, how do I do to store my data/retrieve it through a cloud connection without being "local" in python through mysql?

[DerBjjjg]

Haha, this series makes me remember my first summer job after school. I was in school in Germany and made a Fachabitur which basically means I made a specialised Abitur or requirement for university after having done an apprenticeship in computer science. And well I got a summer job where I was payed for copying data from excel sheets into a form on a website that then would write it in the SQL database of the new ERP of that company.
They sat me into a small room alone so I wouldn't disturb anyone. So for 2 or 3 days I was copying that boring data. But I really was fucking bored.
I analysed the dumb website I was submitting the data to and I don't know who has written it but the whole connection was written there plain for everyone to see. same for the tables the data gets written to etc.
So I took the information to write a code that automatically submits the data for me from a CSV-file.
So I was done with a job that I had 2 months time for, in like 4 or 5 days.
Now I had nearly 2 months in a clima controlled room no one will disturb me in. In the remaining 7 weeks noone controlled if I did my work properly or anything. While I was gaming on my laptop or watching movies and stuff.
After my university days I applied to the company that made that vile ERP that made people type in the data like that. I told the interviewer from my summer job before university. And told him for the right pay I can make CSV import Interfaces for them first and. And then find even better solutions to get the data from other reps to ours. At least data like costumers, suppliers and supplies/materials.
Naturally I got that job and am really paid.

[namelessone]

Does your course on python cover the mysql data also? Also trying to connect to mysql database on my hosting service is there a special connector to do this with. I need to add the port and this to the connection string SslMode="none".