1、首先需要MySQLdb模块
安装方法见本博客中的http://www.guoziweb.com/2014/09/11/importerror-no-module-named-mysqldb/
2、安装mysql数据库
关于mysql的安装,本文不再多述。
3、通过python代码创建数据库、表和插入数据
#!/usr/bin/env python # -*- coding:utf-8 -*- import MySQLdb def main(): try: conn=MySQLdb.connect(host='localhost',user='root',passwd='123456') cur=conn.cursor() cur.execute('create database if not exists mytest') conn.select_db('mytest') cur.execute('create table if not exists test(ID int, IP varchar(32))') cur.execute("insert into test(ID,IP) values(1,'192.168.8.1')") cur.execute("insert into test(ID,IP) values(2,'192.168.8.2')") cur.execute("insert into test(ID,IP) values(3,'192.168.8.3')") '''插入多条''' values=[] for i in range(4,20): values.append((i,'192.168.8.'+str(i))) cur.executemany('insert into test values(%s,%s)', values) '''更新数据库''' cur.execute("update test set IP='192.168.1.1' where ID=1") '''查询结果''' count=cur.execute('select ID,IP from test') print "There's %s rows record." % count for data in cur.fetchall(): '''print 'DeviceID=%s,IP=%s' % data''' print 'ID=%s,IP=%s' % data '''一定要记得提交事务,否则不会对数据库作任何修改''' conn.commit() cur.close() conn.close() except MySQLdb.Error,e: print 'Mysql Error %d:%s' % (e.args[0],e.args[1]) if __name__ == '__main__': main()
- 微信扫码赞助
-
- 支付宝赞助
-