« Previous Next »

Install MySQL Connector via pip (Run in CMD) :

# Command to run in terminal (Not Python code):
# C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts>python -m pip install mysql-connector-python

Output :

[mysql-connector-python installed successfully]

Test MySQL Connector Installation :

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",     # Replace with your MySQL username
  password="yourpassword"  # Replace with your MySQL password
)

print(mydb)

Output :

<mysql.connector.connection_cext.CMySQLConnection object at 0x...>

Insert Record into MySQL Table :

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("John", "Highway 21")

mycursor.execute(sql, val)
mydb.commit()

print(mycursor.rowcount, "record inserted.")

Output :

1 record inserted.

Read All Records from MySQL Table :

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers")

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Output :

('John', 'Highway 21')
...
« Previous Next »