web.py和mysql
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'
