#!/usr/bin/env python
# coding: utf8

import MySQLdb
conn = MySQLdb.connect(host='192.168.1.254', user='root', passwd='root', db='test', charset='utf8', use_unicode=1)
cux = conn.cursor()
print '################# select ##################'
se = "select * from test"
cux.execute(se)
data = cux.fetchall()
print data
print '##################### insert ##################'
inser = 'insert into test2 values(%s, %s)'
cux.executemany(inser, data)
conn.commit()
conn.close()

import pymssql
coms = pymssql.connect(server='192.168.1.66', user='sa', password='sa', database='test', charset='utf8')
cums = coms.cursor()
print '############## mssql insert#####################'
# data = repr(data).decode('UTF-8').encode('GBK')
print data
inser = 'insert into test values(%s, %s)'
cums.executemany(inser,data)
coms.commit()
print ''
print '############### mssql select###################'
cums.executemany(se)
ms = cums.fetchall()
print ms
coms.close()