Breaking News: Grepper is joining You.com. Read the official announcement!

Mysqldb in python

Sujan Ram answered on May 3, 2022 Popularity 6/10 Helpfulness 2/10

answer Mysqldb in python

related python mysqldb

Mysqldb in python

Comment

import MySQLdb

# Connect to the MySQL database
db = MySQLdb.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

# Create a cursor
cursor = db.cursor()

# Create a table
create_table_query = """
CREATE TABLE IF NOT EXISTS example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    age INT
)
"""
cursor.execute(create_table_query)

# Insert data into the table
insert_query = "INSERT INTO example_table (name, age) VALUES (%s, %s)"
data_to_insert = ("John Doe", 30)
cursor.execute(insert_query, data_to_insert)
db.commit()

# Retrieve data from the table
select_query = "SELECT * FROM example_table"
cursor.execute(select_query)
results = cursor.fetchall()

for row in results:
    print(f"ID: {row[0]}, Name: {row[1]}, Age: {row[2]}")

# Close the cursor and the database connection
cursor.close()
db.close()

Popularity 6/10 Helpfulness 2/10 Language sql

Source: chat.openai.com

Tags: python sql

Link to this answer
Share Copy Link

Contributed on Aug 25 2023

Sujan Ram

0 Answers Avg Quality 2/10

Closely Related Answers

python mysqldb

Comment

import MySQLdb

db = MySQLdb.connect(db=dbname, host=dbhost, user=dbuser, passwd=dbpass)

cursor = db.cursor()
cursor.execute("SELECT NOW();")

d = cursor.fetchone()
print("Now: ", d[0])

db.close()

Popularity 9/10 Helpfulness 5/10 Language python

Source: www.geeksforgeeks.org

Tags: python py

Link to this answer
Share Copy Link

Contributed on May 03 2022

Marcus Pereira

0 Answers Avg Quality 2/10

Mysqldb in python

Contents

More Related Answers

Mysqldb in python

Closely Related Answers

python mysqldb

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.