How to insert a variable into a PyMySQL string?

Question

Python

I insert data into the table like this:

cur.execute("INSERT INTO users_data (`user_id`, `name`) VALUES (%s, 'Канал %s');", (member.id, member.display_name,))

The problem is that the output is not 'Канал User_name', but 'Канал 'User_name''. It throws an error

Mistake

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'User_name'')' at line 1")

Answer 1

Form the desired value in the parameters. Quote PyMySQL itself:

cur.execute("INSERT INTO users_data (`user_id`, `name`) VALUES (%s, %s);", (member.id, 'Канал {}'.format(member.display_name))