python+mysql安装及样例

leaper

1。安装mysql_python
　

　$ tar xfz MySQL-python-1.0.0.tar.gz
  $ cd MySQL-python-1.0.0
  $ export mysqlversion="4.0.20"
  $ export mysqlclient="mysqlclient_r"
  $ export mysqloptlibs="ssl crypto"
  $ python setup.py build
  $ su
  # python setup.py install

2。Mysql样例程序

1. #!/usr/bin/env python
   
2. import MySQLdb
   
3. db=MySQLdb.connect(user="root",passwd="123456",db="test")
   
4. curr=db.cursor()
   
5. max_price=5
   
6. curr.execute("""SELECT name, passwd FROM user WHERE id < %s""", (max_price,))
   
7. rows=curr.fetchone()
   
8. print rows[0]
   
9. print rows[1]
   
10. curr.execute('insert into user (name,passwd) values(%s,\'12345\')',(max_price))
    
11. print  curr.insert_id()
    
12. curr.execute('delete from user where id=%s',(max_price))

复制代码

xichen

freebsd 下可以直接ports安装。