python - Python 中从 MySQL 返回的字符串

Question

我尝试使用以下 Python 脚本从 MySQL 数据库检索值:

import mysql.connector
from mysql.connector import errorcode

config_file = {}
try:
  cnx = mysql.connector.connect(<removed.)
except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with your user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exists")
  else:
    print(err)
else:

  cursor = cnx.cursor()

  cursor.execute("SELECT config_key, config_value FROM T_ConfigTable")

  for (config_key, config_value) in cursor:
    print("{}: {}".format( config_key, config_value))
    config_file[config_key] = config_value

  cursor.close

  cnx.close

  print( config_file)

但结果总是返回为:

b'值1':b'值2'

等等

如何去掉 b ？

我使用Python 3.2

感谢您的帮助

Answer 1

您可以使用config_value.decode('utf-8')