$ pip install MySQL-python
python
import MySQLdb
host = 'localhost'
user = 'root'
password = 'password'
database = 'mydatabase'
db = MySQLdb.connect(host=host, user=user, passwd=password, db=database)
python
cursor = db.cursor()
sql = "SELECT * FROM mytable"
cursor.execute(sql)
results = cursor.fetchall()
for row in results:
print(row)
cursor.close()
db.close()
python
cursor = db.cursor()
sql = "INSERT INTO mytable (id, name) VALUES (1, 'John')"
cursor.execute(sql)
db.commit()
sql = "UPDATE mytable SET name='Peter' WHERE id=1"
cursor.execute(sql)
sql = "DELETE FROM mytable WHERE id=1"
cursor.execute(sql)
db.commit()
cursor.close()
db.close()
