python
db = MySQLdb.connect(host="localhost", user="root", passwd="password", db="database_name")
python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="root", passwd="password", db="database_name")
cursor = db.cursor()
sql = "INSERT INTO employees (name, age, address) VALUES ('John', 25, 'New York')"
cursor.execute(sql)
db.commit()
cursor.close()
db.close()
python
import MySQLdb
db = MySQLdb.connect(host="localhost", user="root", passwd="password", db="database_name")
cursor = db.cursor()
sql = "UPDATE employees SET age=26 WHERE name='John'"
cursor.execute(sql)
db.commit()
cursor.close()
db.close()