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 database12 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 db17 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 e26 27 #select data from db28 sql = "select * from test"29 cursor.execute(sql)30 result = cursor.fetchall()31 #the result is a list32 if result:33     for rs in result:34         print rs[0], rs[1]35 36 cursor.close()37 conn.close()

 

Install MySQL-python to connect MySQL