how to add data in a mysql table

so i was creating a menu option where user enters some data and using a function all of that data is added to a MySQL table however the data table is not being updated properly
I have checked there is nothing wrong with the table created so I think the problem lies in the code somewhere

import mysql.connector
def add_det(x1, x2, x3, x4):
                global icode, iname, price, quantity
                try:
                    conn=mysql.connector.connect(host='localhost', database='practicals', user='root', password='root1')
                    cursor=conn.cursor()
                    print("cursor objected created")
                    sql = """#INSERT INTO inventory(item_code, item_name, price, quantity) VALUES (%s,%s,%s,%s)"""
                    t=(x1, x2, x3, x4)
                    print(t)
                    cursor.execute(sql)
                    conn.commit()
                    print(cursor.rowcount, "Records inserted")
                except mysql.connector.Error as e:
                    print("Failed to get record from Mysql table: {}", format(error))
                finally:
                    if conn.is_connected():
                        print("closing...")
                        cursor.close()
                        conn.close()
                        print("Mysql connection is closed")
            add_det(icode, iname, price, quantity)

could anyone pls help me in finding the error?

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

What happens when you remove the # in front of your SQL query?

Or try to change your code with:

sql = """#INSERT INTO inventory(item_code, item_name, price, quantity) 
    VALUES ({}, {}, {}, {})""".format(
    x1, x2, x3, x4
)

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0