Insertrecords

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='127.0.0.1',
                                         database='order_schema',
                                         user='root',
                                         password='root')

    if connection.is_connected():
        db_Info = connection.get_server_info()
        print("Connected to MySQL Server version ", db_Info)
        cursor = connection.cursor()
        cursor.execute("select database();")
        record = cursor.fetchone()
        print("Your connected to database: ", record)

except Error as e:
    print("Error while connecting to MySQL", e)
finally:
    if (connection.is_connected()): 
        print("You can insert data now")
        
count = 1000000

add_employee = ("INSERT INTO orders_table "
               "(equipment_uuid, attribute, value, category_id, category_item_id) "
               "VALUES (%s, %s, %s, %s, %s)")
data_employee = ('5', 'color', 'blackmamba', '5', '5')
cou = 0
for i in range(count):
    cursor.execute(add_employee, data_employee)
    connection.commit()
    print("inserting record", i)
    
cursor.close()
connection.close()