linux python 操作mysql_python 简单操作MySQL

前言

python 配置 mysql

通过 python 爬取一些数据，存入数据库 并生成简单图表

环境

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

测试数据库

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()