[ad_1]
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")
cursor=mydb.cursor()
sql= "INSERT INTO ledger_list VALUES(%s, %s, %s)"
cursor.execute(sql,(ldgrp, ldname, db_name))
mydb.commit()
[ad_2]