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()


上一篇:
下一篇:
切换中文