Insert data into MySQL

    0

    7

    mysql
    Python public recipes

    Raw insertion of value into a MySQL database

    import mysql
    
    # db = mysql.connector.connect(...)
    cursor = db.cursor()
    stmt = "INSERT INTO table (cols) VALUES (%s, %s)"
    cursor.execute(stmt, (values))
    db.commit()
    cursor.close()
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Explore
    • Cookbooks
    • Playground
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.