web.py和mysql

hx0011yy

1、安装easy_install;
sudo apt-get install easy_install;
2、安装web.py和mako
sudo easy_install web.py
Installed /usr/local/lib/python2.7/dist-packages/web.py-0.36-py2.7.egg

sudo easy_install mako
Installed /usr/local/lib/python2.7/dist-packages/MarkupSafe-0.15-py2.7.egg
Using /usr/local/lib/python2.7/dist-packages/Mako-0.6.2-py2.7.egg

3、安装mysql-server
sudo apt-get install mysql-server

4、使用mysql命令；
mysql -u root -p
show databases;
create database testPy；

use testPy；
show tables;
create table users(
    -> id int(11) not null primary key auto_increment,
    -> name char(20) not null,
    -> pwd char(20),
    -> remark char(40));


desc users

select * from users;
quit

5、安装pip，因为mysql-python
sudo apt-get install python-pip
sudo apt-get install python-dev
sudo apt-get install build-essential
sudo pip install mysql-python
Successfully installed mysql-python

sudo apt-get install libmysqld-dev
sudo apt-get install libmysqlclient-dev
6、在web.py中，使用mysql.在python命令行中；
db=web.database(dbn='mysql',dburl="localhost",port=3306,db='testPy',user="root",pw="750301")
result = db.select('users')
result = db.select('users')
row = result[0]
row['pwd']不知道委身有'u'