pip install MySQL-python
python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="mydatabase")
cursor = db.cursor()
# ...
cursor.close()
db.close()
python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="mydatabase")
cursor = db.cursor()
data = [
(1, 'John', 'Doe'),
(2, 'Jane', 'Smith'),
# ...
]
for item in data:
sql = "INSERT INTO mytable (id, firstname, lastname) VALUES (%s, %s, %s)"
cursor.execute(sql, item)
db.commit()
cursor.close()
db.close()
python
import MySQLdb
import csv
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="mydatabase")
cursor = db.cursor()
sql = "SELECT * FROM mytable"
cursor.execute(sql)
results = cursor.fetchall()
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
csvwriter = csv.writer(csvfile)
csvwriter.writerows(results)
cursor.close()
db.close()
