Install MySQL-python to connect MySQL

传送门

 

# yum -y install MySQL-python

运行上面的命令即可安装centos7自带的rpm安装包，但是默认的是为python2.*安装

 

连接MySQL小Demo

 1 #-*- encoding:UTF-8 -*-
 2 import os, sys, string
 3 import MySQLdb
 4 
 5 try:
 6     conn = MySQLdb.connect(host="localhost", user="root", passwd="123456",db="mydatabase")
 7 except Exception, e:
 8     print e;
 9     sys.exit()
10 
11 #Get cursor obj to operator database
12 cursor = conn.cursor()
13 sql = "create table if not exists test(name varchar(128) primary key, age int(3))"
14 cursor.execute(sql)
15 
16 #insert data to db
17 sql = "insert into test(name, age) values ('%s', %d)" % ("coode", 25)
18 sql2 = "insert into test(name, age) values ('%s', %d)" % ("Ben", 19)
19 try:
20     cursor.execute(sql)
21     conn.commit();
22     cursor.execute(sql2)
23     conn.commit()
24 except Exception, e:
25     print e
26 
27 #select data from db
28 sql = "select * from test"
29 cursor.execute(sql)
30 result = cursor.fetchall()
31 #the result is a list
32 if result:
33     for rs in result:
34         print rs[0], rs[1]
35 
36 cursor.close()
37 conn.close()

 

posted on 2015-11-15 23:00  hutaishi  阅读(343)  评论(0)  编辑  收藏  举报

导航