MySQL With Python
Setup For Work step 1: Install MySQL in your system (Note* please remember root password) step 2: create a database in the name 'db10' step 3: create a virtual environment (if you don't know then visit here ) step 4: pip install mysql-connector-python step 5: Now create a python script and try with the below code Code Connecting Database: import psycopg2 import mysql.connector def connect_my_db (db, user, password, host): try: connection = mysql.connector.connect( database=db, user = user, password = password, host = host, port = "3306") print("Database Connected") return connection except Exception as e: print("Unable to connect DB") connection = connect_my_db('db10', 'root', '12345', 'localhost') Create Table : import mysql.conn...