python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database")
cursor = db.cursor()
cursor.execute("SELECT * FROM table")
results = cursor.fetchall()
for row in results:
print(row)
db.close()
python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database")
cursor = db.cursor()
sql = "INSERT INTO table (column1, column2) VALUES ('value1', 'value2')"
cursor.execute(sql)
db.commit()
db.close()
python
import MySQLdb
try:
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database")
except MySQLdb.Error as e:
print("MySQL Error [%d]: %s" % (e.args[0], e.args[1]))
