Python link MySQL

1. Installing MYSQLDB

MYSQLDB is the interface for the Python link MySQL database, which implements the Python database API specification V2.0, built on the MySQL C API.

：

http://sourceforge.net/projects/mysql-python/files/mysql-python/

I downloaded the 1.2.3 version

2. Code

1 #!/usr/bin/python2 #-*-coding:utf-8-*-3 ImportMySQLdb4 #Open a database connection5db = MySQLdb.connect (host='127.0.0.1', port=3306, user='Root', passwd="', db='XXX', charset='UTF8')6 #get an operation cursor using the cursor () method7cursor =db.cursor ()8 #executing SQL statements using the Execute method9Cursor.execute ("SELECT VERSION ()")Tendata =Cursor.fetchone () One Print "MySQL Version%s"%Data A #To close a database connection -Db.close ()

This is the most basic of a small example

Python link MySQL