3 - PythonAnywhere - Create table in MySQL database

Creating a table in MySQL (states) database using MySQL console and SQL Create Table command in PythonAnywhere cloud-based IDE. Records to be inserted in following video (Part 2).
Link to states.txt database content (used in video):
rmhoma.github.io/

[@nuwairaabdullahi7146]

This is the most well explained tutorial . Thank you.

[@jarjarjar9006]

Great video!

[@saikatmukherjee8095]

if i have a database in my local computer and put it on git and then pull on pythonanywhere consol.... so where should i use makemigrations or migrate things , i an not getting

[@homastudio45]

PythonAnywhere is a nice place to start learning about databases and SQL, but you can't use php. Goorm would be a better place for that, plus you have access to phpMyAdmin to export databases, change passwords, use PHP, etc. PythonAnywhere (free version) is not meant to be accessible outside. It's great for education/learning, as is Goorm, but the free versions are basically cloud versions of a local environment like AMPPS or MAMP, etc. Your database should be an .sql file that you can migrate anywhere. You can migrate from a local environment to a web server - typically using phpMyAdmin (on your end and then on the end of your web host). I'm not sure how Git.Github handles that. I will post a migrating video in the future (local to GoDaddy for example).

[@zebasxa5933]

may can you show how to connect with your python code?

[@homastudio45]

I will do that. For now, I did record a quick exercise where I introduce MySQL Connector to my students. It's not much, but may get you started in the right direction.
ruclips.net/video/ulAp1HjckyY/видео.html

[@RedNel730]

Odd. When I entered show tables, after creating new database, it showed error.