python 实现从数据库中获取某个字段的值

importpandas,pymysql

dbconn = pymysql.connect(
host="数据库ip",
database="数据库名",
user="数据库登录账号",
passwd="数据库登录密码",
port=3306,
charset="utf8"
)
sqlcmd ="SQL语句"

conn = pandas.read_sql(sqlcmd, dbconn)
code = conn.iloc[0,1]#获取code



b = conn["description"]#获取description字段的值
c= conn[0:2]#切片，分成2行显示
d= conn.iat[0,2] ="we are"