详解文稿详解python-mysql.pdfVIP

MySQL

#安装mysqlpython模块

$gunzipMySQL-python-1.2.2.tar.gz

$tar-xvfMySQL-python-1.2.2.tar

$cdMySQL-python-1.2.2

$pythonsetup.pybuild

$pythonsetup.pyinstall

MySQL

#-*-encoding=utf-8-*-

importMySQLdb

#连接,顺序为主机，用户名，，数据库

db=MySQLdb.connect(localhost,root,root,python)

#游标，游标建立自动开启事务。

curdb.cursor()

#执行sql

cur.execute(selectversion());

#提取数据

datacur.fetchone()

printdata

db.close()

MySQL

#-*-encoding=utf-8-*-

#建库

sql=

createtableemp(idintprimarykeyauto_increment,

namevarchar(20),

ageint)

cur.execute(sql);

db.close()

MySQL

#-*-encoding=utf-8-*-

#事务

sqlinsertinto...

try:

cur.execute(sql);

mit();

except:

db.rollback();

db.close()

MySQL

#-*-encoding=utf-8-*-

#查询

sqlselect*fromempwherenamelike%s%(tom%)

try:

cur.execute(sql);

resultscur.fetchall();

forrowinresults:

fnamerow[0];

...

except:

db.rollback();

db.close()

MySQL

#-*-encoding=utf-8-*-

#updateDelete

sqlupdateempsetageage+1whereid1

sqldeletefromempwhereid%d%(3)

try:

cur.execute(sql);

mit()

except:

db.rollback();

db.close()