#!/usr/bin/env python # -*-coding:UTF-8-*-#这一句告诉python用UTF-8编码 #========================================================================= # # NAME: Python MySQL test # # AUTHOR: benyur # DATE : 2004-12-28 # # COMMENT: 这是一个python连接mysql的例子 # #=========================================================================
""" ***** This is a MySQL test ***** select: conn=Connection() conn.select_db('test') cur=conn.cursor() cur.execute('select * from user') cur.scroll(0) row1=cur.fetchone() row1[0] row1[1] row1[2] insert: cur.execute('insert into user (name,passwd) values(\'benyur\',\'12345\')') cur.insert_id() update: cur.execute('update user set passwd=\'123456\' where name=\'benyur\'') delete: cur.execute('delete from user where id=2') ********************************** """
from MySQLdb import *
def conn(): conn=Connection() conn.select_db('test') cur=conn.cursor() cur.execute('select * from user') cur.scroll(0) row1=cur.fetchone() row1[0] row1[1] row1[2]
def usage(): print __doc__
if __name__=='__main__': usage() |