Python to MySQL Connection

Database Management using Python

connection	Python MySQL connection string
rowcount	Number of rows affected due to Query
error	Capturing Error in MySQL Query
Collect records	Select Query to get records from database table
Add record	Insert Query to add record to database table
Update record	Update Query to update records of a database table
Delete record	Delete records of a database table
read_sql	Using MySql records to create Pandas DataFrame
mysqlclient	Using sqlalchemy and create_engine to manage MySQL

Installing MySQL connection from Anaconda

Before this you must have MySQL database running and keep your connection userid and password with your database name ready.

We need to install MySQL connector to connect from Python to MySQL database.

Inside Anaconda goto Environment at your left side navigational menu
MySQL installation from Anaconda

Middle you can see Base root
From Base root select Open Terminal
MySQL installation from Anaconda

You will reach the Anaconda terminal where you can install any package . Just enter this line at the prompt to install MySQL connector.

conda install -c anaconda mysql-connector-python

This will install your MySQL connector by downloading packages from the internet. Now it is time to check the connection.

MySQL Connecting string

Using sqlalchemy

For updating the database you need to use sqlalchemy and its create_engine
Here is the code to get the connection by using sqlalchemy

from sqlalchemy import create_engine
engine = create_engine("mysql+mysqldb://userid_here:password_here@localhost/db_name")
my_conect = engine.connect()

If you are getting error message like this.
No module named 'MySQLdb'
then you need to install mysqlclient.
Open your Anaconda terminal as explained above and then enter

pip install mysqlclient

MySQL Connection Collect records Python- Tutorials

Python MySQL connection

Installing MySQL connection from Anaconda

Using sqlalchemy