Use of the Python mysqldb module

MYSQLDB Module

An example of a simple link database

# _*_ Coding:utf-8 _*_import mysqldb #使用mysqldb模块conn = MySQLdb.connect (host= ' 127.0.0.1 ', user= ' roo T ', passwd= ' 123456 ', db= ' python ') #建立连接cursor = Conn.cursor () #获取游标cursor. exe Cute (' INSERT into people (Name,age,sex) VALUES (\ ' jee\ ', 21,\ ' f\ ') ') #执行命令conn. Commit () #提交数据cursor. Close () #关闭游标conn. Close () #关闭数据库连接

This article is from the "Eight Miles" blog, so be sure to keep this source http://5921271.blog.51cto.com/5911271/1574001

Use of the Python mysqldb module