Basic use of Python MySQL

1. Installation

MYSQLDB is the interface for the Python link MySQL database, which implements the Python database API specification V2.0, based on the MySQL C API
The installation method is as follows

# Yum Install python-devel# pip install Mysqlclient

2. Basic use

Basic use methods such as

The following code queries all the items in the user table in the test database

 import   MySQLdb  try  : Conn  =mysqldb.connect (Host= " localhost   ", User=  root   ", passwd=  " root   ", Db="   Test   ", Port=3306) cur  =conn.cursor () Cur.execute (  " select * from user   " )  

    conn.commit ()    cur.close ()    conn.close ()except  mysqldb.error,e:       Print"Mysql Error%d:%s" % (E.args[0], e.args[1])

Reference:
<python working with MySQL database >
<python working with MySQL database >
<python How to use MySQL database and an example >
<pep 249--Python Database API specification v2.0>

Basic use of Python MySQL