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()
数据库示例:
mysql> select * from test_table;
+----+--------+------+------+-------+-------+------+
| Id | DiskId | Name | Sg | PhyId | Model | SN |
+----+--------+------+------+-------+-------+------+
| 1 | 1 | NULL | NULL | NULL | NULL | NULL |
| 2 | 2 | NULL | NULL | NULL | NULL | NULL |
| 3 | 3 | NULL | NULL | NULL | NULL | NULL |
| 4 | 4 | NULL | NULL | NULL | NULL | NULL |
| 5 | 5 | NULL | NULL | NULL | NULL | NULL |
| 6 | 6 | NULL | NULL | NULL | NULL | NULL |
| 7 | 7 | NULL | NULL | NULL | NULL | NULL |
| 8 | 8 | NULL | NULL | NULL | NULL | NULL |
+----+--------+------+------+-------+-------+------+
8 rows in set (0.00 sec)
mysql> describe test_table;
+------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| DiskId | varchar(25) | YES | | NULL | |
| Name | varchar(25) | YES | | NULL | |
| Sg | varchar(25) | YES | | NULL | |
| PhyId | varchar(25) | YES | | NULL | |
| Model | text | YES | | NULL | |
| SN | text | YES | | NULL | |
+------------+-------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)
参考资料:http://www.cnblogs.com/fnng/p/3565912.html