http://mysql-python.sourceforge.net/
记录下
http://mysql-python.sourceforge.net/
记录下
- #!/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()
