Access the MySQL 2.7 database on the Python 5.0 platform

In other words, download mysql-python-1.2.3.win32-py2.7.exe

Is:

Free in http://linux.bkjia.com/

The username and password are both www.bkjia.com

The specific download directory is/pub/2011/12/07/access the MySQL 2.7 database on the Python 5.0 platform/

You can find the installation package in it. After installation, it will automatically install the mysql file in python 2.7/lib/site-package. After installation, no other configuration will be made, you can use it directly.

The following is an example to illustrate how to use python to access the mysql database,

See the following example:

2. '''
4. Created on 2011-11-29
6. @ Author: LONMID
7. '''
8. Import MySQLdb
9. Conn=MySQLdb. Connect (User='Root',Passwd='123',Db='Example');
10. Cur=Conn. Cursor ();
11. Cur.exe cute ("select id, lastname, firstname, date_format (dob, '% Y-% m-% d % H-% I-% s '), phone from employee ");
12. # Select username, password, date_format (reg_date, '% Y-% m-% d % H-% I-% s') as date from reg_user
13. For data in cur. fetchall ():
14. Print data;
15. Cur. close ();
16. Conn. commit ();
17. Conn. close ();

If no error is reported, mysql can be used.