The Python MySQLdb module connects to the mysql database instance

mysql is an excellent open source database. It is now widely used, so it is necessary to briefly introduce how to operate mysql database with python. The python operation database requires the installation of a 3rd party module, which is available for download and documentation in http:// mysql-python.sourceforge.net /.

Since the database module of python has a special specification for the database module, in fact, no matter which database method is used, it is more or less the same, here is a section of the code demonstration:

#-*- encoding: gb2312 -*-
import os, sys, string
import MySQLdb

#  Connect to database 
try:
  conn = MySQLdb.connect(host='localhost',user='root',passwd='xxxx',db='test1')
except Exception, e:
  print e
  sys.exit()

#  To obtain cursor Object to operate on 

cursor = conn.cursor()
#  Create a table 
sql = "create table if not exists test1(name varchar(128) primary key, age int(4))"
cursor.execute(sql)
#  Insert data 
sql = "insert into test1(name, age) values ('%s', %d)" % ("zhaowei", 23)
try:
  cursor.execute(sql)
except Exception, e:
  print e

sql = "insert into test1(name, age) values ('%s', %d)" % (" zhang 3", 21)
try:
  cursor.execute(sql)
except Exception, e:
  print e
#  Insert multiple 

sql = "insert into test1(name, age) values (%s, %s)" 
val = ((" li 4", 24), (" The king 5", 25), (" hong 6", 26))
try:
  cursor.executemany(sql, val)
except Exception, e:
  print e

# Query out data 
sql = "select * from test1"
cursor.execute(sql)
alldata = cursor.fetchall()
#  If any data is returned, the output is looped , alldata There is a 2 The list of d 
if alldata:
  for rec in alldata:
    print rec[0], rec[1]


cursor.close()

conn.close()