1、安装MySQL
2、安装MySQL-python
pip install MySQL-python
安装的时候会有些问题出现,但是使用百度或者谷歌很好解决,没做记录
3、安装logging(此处的logging只是附加的)
pip install logging
4、代码:
#!/usr/bin/python
#coding:utf-8
import MySQLdb
import logging
#使用默认的rootlogger
logger = logging.getLogger()
#level:设置rootlogger的日志级别
#filename:日志存储文件
#format:指定日志显示格式
#filemode:文件打开方式
logging.basicConfig(level=logging.DEBUG,
format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s',
datefmt='%a, %d %b %Y %H:%M:%S',
filename='test.log',
filemode='w')
db_config = {
'host':'localhost',
'port':3306,
'user':'root',
'passwd':'root',
'db':'test2',
}
conn= MySQLdb.connect(
host=db_config['host'],
port = db_config['port'],
user=db_config['user'],
passwd=db_config['passwd'],
db =db_config['db'],
)
logger.info('已连接数据库')
cur = conn.cursor()
logger.info('获取游标')
#建表
logger.info('建表')
cur.execute("create table users(name varchar(10),fullname varchar(40),password varchar(40))")
#插入数据
logger.info('插入一段数据')
test = "insert into users values(%s,%s,%s)"
cur.executemany(test,[('yin','yin sss','yin123'),
('zhou','zhou lei','zhou123'),
('zhang','zhang san','zhang123')])
#更新
logger.warning('数据更新')
cur.execute("update users set fullname='zhou lei lei' where name = 'zhou'")
conn.commit()
logger.warning('数据更新提交')
#查询
cur.execute("select * from users")
logger.info('查询数据')
users = cur.fetchall()
for user in users:
print user
4、总结:
(1)连接数据库
(2)获取游标
(3)获取游标后就可以对数据库进行操作,使用SQL语句。
(4)具体使用
http://mysql-python.sourceforge.net/MySQLdb.html