把做工程过程中常用的内容备份一下,如下的资料是关于python通过MySQLdb模块链接数据库并添加数据完整演示的内容,希望能对码农们也有帮助。
#!/usr/bin/python
import MySQLdb
Open database connection
db = MySQLdb.connect(“localhost”,“testuser”,“test123”,“TESTDB” )
prepare a cursor object using cursor() method
cursor = db.cursor()
Prepare SQL query to INSERT a record into the database.
sql = “”“INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME, AGE, SEX, INCOME)
VALUES (‘Mac’, ‘Mohan’, 20, ‘M’, 2000)”""
try:
Execute the SQL command
cursor.execute(sql)
Commit your changes in the database
db.commit()
except:
Rollback in case there is any error
db.rollback()
disconnect from server
db.close()