top of page

Python MySQL Database Operations Example with mysql.connector

import mysql.connector

    # Establish a connection to the MySQL database
    con = mysql.connector.connect(host="localhost", port=3306, user="username", password="password", database="Education")

    # Create a cursor to execute SQL queries
    cursor = con.cursor()

    # Insert records into the "student" table
    cursor.execute("INSERT INTO student VALUES('Eliza', 104)")
    cursor.execute("INSERT INTO student VALUES('Kattie', 105)")
    cursor.execute("INSERT INTO student VALUES('Jack', 106)")

    # Execute a SELECT query to retrieve all records from the "student" table
    cursor.execute("SELECT * FROM student")

    # Print the results of the SELECT query
    for r in cursor:
        print(r[0], r[1])

    # Commit the changes to the database

except mysql.connector.Error as e:
    print("Connection Unsuccessful:", e)

    # Close the cursor and connection in the finally block to ensure proper cleanup

1 view0 comments

Recent Posts

See All

Test case for Valid Coupon Code

This test case checks whether a valid coupon code is successfully applied to a booking cart, the total is updated accordingly, and a success message is displayed. package com.seleniumExamples2024; pu

Keyboard shortcut keys for various operations

General Shortcuts: Ctrl + C: Copy Ctrl + X: Cut Ctrl + V: Paste Ctrl + Z: Undo Ctrl + Y: Redo Ctrl + A: Select All Ctrl + S: Save Ctrl + P: Print Ctrl + F: Find Windows Shortcuts: Windows Key: Open or


Avaliado com 0 de 5 estrelas.
Ainda sem avaliações

Adicione uma avaliação
bottom of page