展开全部
MySQL数据库的varchar类型数据在Python中是str类型。#coding=utf-8
import MySQLdb
conn= MySQLdb.connect(
host='192.xxx.xxx.xxx',
port = 3306,
user='root',
passwd='PASSWORD',
db ='testDB',
)
cur = conn.cursor()
datanum=cur.execute("select DiskId from test_table;")
print datanum
info = cur.fetchmany(datanum)
for temp in info:
print temp[0]
print type(temp[0]) #打印类型
cur.close()
conn.commit()
conn.close()
数据库示例:32313133353236313431303231363533e78988e69d8331333363373134mysql> select * from test_table;
+----+--------+------+------+-------+-------+------+
| Id | DiskId | Name | Sg | PhyId | Model | SN |
+----+--------+------