Operate mysql database with python (simple "insert data" operation)

#! / usr/bin/env python#-*-coding: utf-8-* -''1, the database environment here is local database 2, the database I want to operate through python is test_db3, there is a table in this database, the table name is: user4, table field: id, name, address5, in which the id field is self-increasing and is also the primary key 6. Because the ID field is self-increasing, the number will be added when inserting the data. So there is no need to insert additional data''import MySQLdb# to establish a connection conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='1qaz#EDC',db='test_db') cur = conn.cursor () # to operate on the data sql = "insert into user (name,address) values (% s)% s)" # defines a sql statement, and% s defines parameters for the placeholder params = (' tantianran','GuangZhou') # These two parameters correspond to the above placeholder res = cur.execute (sql,params) # execute the sql statement conn.commit () # submit the request, otherwise the data will not be written to the database # close the database connection cur.close () conn.close () print res # print out the number of entries affected by the execution of this sql statement