Question

Hello, I'm working on inserting data into a table using MySQL and Python on my Windows OS laptop; and I am asked to modify the script so that it executes an insert query in one of my database tables. I am also asked to print the table before and after I execute this query in order to ensure the new information was inserted into the table.

I'd like to INSERT INTO my EMPLOYEE table. The columns are

employee_id, employee_password, order_id and the values are 34, 'jgl9od4', 204 but I cannot figure out how to actually insert the data into the table in mySQL.

I have already connected Python and mySQL via importing pyodbc and used it to SELECT rows from my table in mySQL and have them printed into my Python console.

Could you please direct me on the steps to take to modify my previous script to execute an insert query?

Here is my previous script:

import pyodbc

conn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};"
"Server=DESKTOP-ABCDEFG;"
"Database=Pizza Ordering;"
"Trusted_Connection=yes;")

cursor = conn.cursor()
cursor.execute('SELECT * FROM customers')

for row in cursor:
print('row = %r' % (row,))  

Answer 1

cursor.execute("INSERT INTO Emoloyee(employee_id,employee_password,order_id) VALUES(34,'jgl9od4', 204)")
conn.commit()
#This commit statement will commit the records into the employee table without this commit method , Entries will not be reflected in the table.

Yes you have already connected python and mysql via pyodbc connector .

Just execute insert query with above command.

Hey if you like my answer please give a thumbsup and if you have any query please get back to me in comment section will be happy to help you.