ejemplo de código de inserción cursor.execute python

Tenemos la contestación a este asunto, al menos eso creemos. Si sigues con inquietudes dínoslo, que para nosotros será un gusto ayudarte

Ejemplo: python mysql inserta varias filas

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',database='Electronics',user='pynative',
                                         password='[email protected]#29')

    mySql_insert_query ="""INSERT INTO Laptop (Id, Name, Price, Purchase_date) 
                           VALUES (%s, %s, %s, %s) """

    records_to_insert =[(4,'HP Pavilion Power',1999,'2019-01-11'),(5,'MSI WS75 9TL-496',5799,'2019-02-27'),(6,'Microsoft Surface',2330,'2019-07-23')]cursor= connection.cursor()cursor.executemany(mySql_insert_query, records_to_insert)
    connection.commit()print(cursor.rowcount,"Record inserted successfully into Laptop table")except mysql.connector.Error as error:
    print("Failed to insert record into MySQL table ".format(error))

finally:
    if(connection.is_connected()):
        cursor.close()
        connection.close()print("MySQL connection is closed")

---

---

Utiliza Nuestro Buscador