Advanced Python connection to MySQL code

Let's first look at the Python connection MySQL code :#! Usrbinenvpython #-*-coding: UTF-8-*-# This statement tells python to use UTF-8 encoding #

Let's first look at the Python connection MySQL code :#! /Usr/bin/env python #-*-coding: UTF-8-*-# This sentence tells python to use UTF-8 encoding #========================

Let's first look at the Python connection MySQL code:

#! /Usr/bin/env python
#-*-Coding: UTF-8-*-# This statement tells python to use UTF-8 Encoding
#===================================================== ========================================
#
# NAME: Python MySQL test
#
# AUTHOR: benyur
# DATE: 2004-12-28
#
# COMMENT: this is an example of python connection to mysql.
#
#===================================================== ========================================

""
* ***** This is a MySQL test *****

Select:
Conn = Connection ()
Conn. select_db (test)
Cur = conn. cursor ()
Cur.exe cute (select * from user)
Cur. scroll (0)
Row1 = cur. fetchone ()
Row1 [0]
Row1 [1]
Row1 [2]

Insert:
Cur.exe cute (insert into user (name, passwd) values (\ benyur \, \ 12345 \))
Cur. insert_id ()

Update:
Cur.exe cute (update user set passwd =\123456 \ where name = \ benyur \)

Delete:
Cur.exe cute (delete from user where id = 2)

**********************************
""

From MySQLdb import *

Def conn ():
Conn = Connection ()
Conn. select_db (test)
Cur = conn. cursor ()
Cur.exe cute (select * from user)
Cur. scroll (0)
Row1 = cur. fetchone ()
Row1 [0]
Row1 [1]
Row1 [2]

Def usage ():
Print _ doc __

If _ name __=__ main __:
Usage ()

MySQLdb:
Download and decompress the package to the % Python_HOME % \ Lib \ site-packages directory. python will automatically find the package.
MySQLdb is basically the Python version of MySQL c api and follows the Python Database API Specification v2.0.