python mysql html_如何使用python在MySQL表中存储html

好吧，这是我的密码。希望你能帮助我。我正在使用名为MySQLdb的MySQL库。在def createNick(self, user, nick):

try: # TRY STATEMENT HERE SO THE NICK CAN BE RECREATED

db = m.connect("host", "user", "password", "database")

cur = db.cursor()

cur.execute("CREATE TABLE nick_%s(name TEXT NOT NULL)" % user.lower())

cur.execute('INSERT INTO nick_%s(name) VALUES("%s")' % (user.lower(), nick))

db.commit()

except:

db = m.connect("host", "user", "password", "database")

cur = db.cursor()

cur.execute("DROP TABLE nick_%s" % user.lower())

cur.execute("CREATE TABLE nick_%s(name TEXT NOT NULL)" % user.lower())

cur.execute('INSERT INTO nick_%s(name) VALUES("%s")' % (user.lower(), nick))

db.commit()

def getNick(user):

db = m.connect("host", "user", "password", "database")

cur = db.cursor()

cur.execute("SELECT * FROM nick_%s" % user.lower())

nick = [nick[0] for nick in cur.fetchall()]

try: # TRY STATEMENT HERE JUST INCASE USER DID NOT MAKE ONE

return nick

except:

return user

self.createNick("username","nickname")

print self.getNick("username")

output: nickname

我的问题是，每次我调用函数时，它都不能正确地表达HTML。我什么都试过了，你能帮忙吗？在