SET link = '%s'
WHERE id = '%s'
query = """/*!40101 SET @saved_cs_client = @@character_set_client */;
DROP TABLE IF EXISTS {};
CREATE TABLE {}
...
""".format(name, name)
cursor.execute(query)
body = params.get('body')
txt_body = ... # перевести в текст, например через html2text: https://pypi.org/project/html2text/
message.add_content(txt_body , 'text/plain')
message.add_content(body, 'text/html')
lst = [1, 2, 3]
lst2 = lst
a = [lst] * 3 # a = [[1, 2, 3], [1, 2, 3], [1, 2, 3]]
lst[1] = 17 # a = [[1, 17, 3], [1, 17, 3], [1, 17, 3]], lst2 = [1, 17, 3]
if password2 == password1:
cur.execute("INSERT INTO data VALUES(?,?,?)", (login,email,password1))