python连接mysql数据库

python连接mysql数据库[复制链接]

  

xieao

电梯直达

1^#

发表于 2008-12-6 12:39:00|只看该作者|倒序浏览

1.   平台及版本 WkFTechFeel
linux 内核2.6，gcc 3.4.4，glibc 2.4 WkFTechFeel
python 2.4.3 WkFTechFeel
mysql 5.0.19 WkFTechFeel
mysql-python 1.2.1-p2 WkFTechFeel
2.   安装mysql-python WkFTechFeel
tar xvfz MySQL-python-1.2.1_p2.tar.gz WkFTechFeel
cd MySQL-python-1.2.1_p2 WkFTechFeel
python setup.py build WkFTechFeel
python setup.py install WkFTechFeel
WkFTechFeel
3.   使用 WkFTechFeel
import MySQLdb WkFTechFeel
3.1.   连接 WkFTechFeel
conn =   MySQLdb.Connection(host, user, password, dbname) WkFTechFeel
3.2.   选择数据库 WkFTechFeel
conn.select_db(’database name’) WkFTechFeel
3.3.   获得cursor WkFTechFeel
cur =   conn.cursor() WkFTechFeel
3.4.   cursor位置设定 WkFTechFeel
cur.scroll(int, mode) WkFTechFeel
mode可为相对位置或者绝对位置，分别为relative和absolute。 WkFTechFeel
WkFTechFeel
3.5.   select WkFTechFeel
cur.execute(‘select clause’) WkFTechFeel
例如 WkFTechFeel
cur.execute(‘select * from mytable’) WkFTechFeel
WkFTechFeel
row = cur.fetchall() WkFTechFeel
或者： WkFTechFeel
row1 = cur.fetchone() WkFTechFeel
3.6.   insert WkFTechFeel
cur.execute(‘inset clause’) WkFTechFeel
例如 WkFTechFeel
cur.execute(‘insert  into table (row1, row2) values (\’111\’, \’222\’)’) WkFTechFeel
WkFTechFeel
conn.commit() WkFTechFeel
WkFTechFeel
3.7.   update WkFTechFeel
cur.execute(‘update  clause’) WkFTechFeel
例如 WkFTechFeel
cur.execute(“update  table set   row1 = ‘’  where  row2 = ‘row2 ‘  ”) WkFTechFeel
WkFTechFeel
conn.commit() WkFTechFeel
WkFTechFeel
3.8.   delete WkFTechFeel
cur.execute(‘delete  clause’) WkFTechFeel
例如 WkFTechFeel
cur.execute(“delete from  table  where   row1 = ‘row1’  ”) WkFTechFeel
WkFTechFeel
conn.commit() WkFTechFeel