python - 我以元组形式获取 SELECT mysql 值。如何以字符串形式获取它?
问题描述
mycursor.execute("SELECT Name FROM employee_details")
names = (mycursor.fetchall())
for y in names:
print (y)
结果:
('dsf',)
('Gai',)
('egw',)
('qwr',)
('Sam',)
我想要的结果:
dsf
Gai
egw
qwr
Sam
解决方案
cursor.fetchall()
返回元组列表。您可以使用索引访问元组中的单个值。
for y in names:
print (y[0])
推荐阅读
- c# - The more you add hours to a DateTime class the more time you loss
- reinforcement-learning - Limit on Action Change in reinforcement learning
- c++ - unordered_set 与链表查找之间的性能比较
- etl - tPartitioner, tCollector & tRecollector talend DI
- sqlite - 简单的 Flutter sqflite login->write to db->navigate->retrieve from db flow
- c++ - 排序算法和对象指针的问题
- javascript - Why is non-reachable part of ternary operator evaluated before state update via setTimeout?
- apache-kafka - Does Kafka stand alone connector syncs automatically or it needs restart every time
- java - android.database.sqlite.SQLiteException:没有这样的列:名称(代码 1)
- html - 如何在 HTML 的特定区域中阻止右键单击?