import pymysql
conn = pymysql.connect(host=‘192.168.1.210‘, port=3306, user=‘root‘, passwd=‘ubuntu‘,
db=‘mysql‘)
cur = conn.cursor()
cur.execute("show full columns from trade")
row_1 = cur.fetchone()
print (row_1)
原文：http://www.cnblogs.com/peterinblog/p/7182471.html