Install MySQL-python to connect MySQL

 1 #-*- encoding:UTF-8 -*-
 2 import os, sys, string
 3 import MySQLdb
 4 
 5 try:
 6     conn = MySQLdb.connect(host="localhost", user="root", passwd="123456",db="mydatabase")
 7 except Exception, e:
 8     print e;
 9     sys.exit()
10 
11 #Get cursor obj to operator database
12 cursor = conn.cursor()
13 sql = "create table if not exists test(name varchar(128) primary key, age int(3))"
14 cursor.execute(sql)
15 
16 #insert data to db
17 sql = "insert into test(name, age) values (‘%s‘, %d)" % ("coode", 25)
18 sql2 = "insert into test(name, age) values (‘%s‘, %d)" % ("Ben", 19)
19 try:
20     cursor.execute(sql)
21     conn.commit();
22     cursor.execute(sql2)
23     conn.commit()
24 except Exception, e:
25     print e
26 
27 #select data from db
28 sql = "select * from test"
29 cursor.execute(sql)
30 result = cursor.fetchall()
31 #the result is a list
32 if result:
33     for rs in result:
34         print rs[0], rs[1]
35 
36 cursor.close()
37 conn.close()