inserting into a database (mysql) via a python program [duplicate]

SQLAlchemy is good: https://www.sqlalchemy.org/

Otherwise, using the conn/cur as you described is easy: https://www.tutorialspoint.com/python/python_database_access.htm

Go though the documentation to get yourself familiar with python, mysql and how to work with them together.

Although, the minimal code would look something like this :

import MySQLdb

query = "insert into DB_NAME values (1,2)"

try : 
    conn = MySQLdb.connect(host="",
        user="",
        passwd="",
        db="")
    cursor = conn.cursor()
    cursor.execute(query)
    conn.commit()
    cursor.close()
    conn.close()
except  (MySQLdb.Error, Exception) as error :
    print error
    print "Insert data unsuccessful"

See the code below

import mysql.connector

from mysql.connector import MySQLConnection, Error

class SQL_Connect:

def __init__(self):
    #-------------------------------------------------------
    # Database Connection Param's
    self.host_Address = 'Host Here'
    self.database_Name = 'Database Name'
    self.userName = 'User Name'
    self.db_Password = 'Password'
    #-------------------------------------------------------


def insert_IntoDB(self, Manufacturer, partNum, formFactor, socket, chipSet, memSlots, memType, maxMem, raidSup, onboardVid, crosFire_Sup, sli_Sup, sata6GBS, sataExpress, onboard_Ether):
    test_Query = 'INSERT INTO motherboards (Manufacturer, modelNum, formFactor, socket, chipset, memSlots, memType, maxMem, raidSup, onboardVid, crosfireSup, sliSup, sata6GBS, sataExpress, onboardEther) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
    args = (Manufacturer, partNum, formFactor, socket, chipSet, memSlots, memType, maxMem, raidSup, onboardVid, crosFire_Sup, sli_Sup, sata6GBS, sataExpress, onboard_Ether)
    try:
        conn = mysql.connector.connect(host = self.host_Address, database = self.database_Name, user = self.userName, password = self.db_Password)
        if conn.is_connected():
            print 'MySQL Database Connection Established'
        cursor = conn.cursor()
        cursor.execute(test_Query, args)

        conn.commit()
        print 'Data Inserted!!!'

    except Error as e:
        print ('ERROR: ',e)

    finally:
        cursor.close()
        conn.close()