前言
- python 配置 mysql
- 通過 python 爬取一些數(shù)據(jù)，存入數(shù)據(jù)庫 并生成簡單圖表
環(huán)境
linux (Ubuntu)
安裝
1-MySQL
$ sudo apt-get install mysql-server
2-MySQL-python
sudo apt-get install python-setuptools
sudo apt-get install libmysqld-dev
sudo apt-get install libmysqlclient-dev
sudo apt-get install python-dev
sudo easy_install mysql-python
安裝成功之后龄句，終端進入python,然后測試
1.png
測試數(shù)據(jù)庫
Create a database name ‘book’ in your mysql
2.png
3.png
Connect to MySQL
4.png
Create table user
5.png
Insert record into your table user
6.png
Output the record from your table user
7.png
Run the program
8.png
小例子
import sys
import MySQLdb
db = MySQLdb.connect(host='localhost',user='root',passwd='root',db='hello')
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()
# print "Database version : %s " % data
#---------------------------------------------------
# sql = "create table if not exists test2(name varchar(128) primary key, age int(4))"
# cursor.execute(sql)
sql = "insert into test2(name, age) values ('%s', %d)" % ("ccc", 21)
try:
cursor.execute(sql)
except Exception, e:
print e
db.commit()
sql = "select * from test2"
cursor.execute(sql)
alldata = cursor.fetchall()
if alldata:
for rec in alldata:
print rec[0], rec[1]
db.close()
