A easy program containing sql reference to mysql.connector work fantastic with .py however not working whereas operating executable file (made with pyinstaller), For sql server workbench is used.

following is connection codes

mydb = mysql.connector.join(host="localhost", consumer="root", passwd="Abcd11",database="entry",auth_plugin="mysql_native_password")


sql= "INSERT INTO ledger_list VALUES(%s, %s, %s)"
cursor.execute(sql,(ldgrp, ldname, db_name))


By admin

Leave a Reply

Your email address will not be published. Required fields are marked *