Insert data into MySQL

    0

    16

    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
    • Playground
    • Snippets
    • Cookbooks
    Legal
    • Security
    • Privacy Policy
    • Code Privacy
    • Terms of Service
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.