How to pass long text in query to MySQL from python?

Question

MySQL

I need to store the text along with hyphens, but the mysql library for python requires sending the request as a string, in which the correct transfer of hyphens cannot be arranged.
I write a query like:

query = "INSERT INTO table (id, name, text) " + 
"VALUES (" + str(id) + ", \'" + name + "\', \'" + text + "\') "

Answer 1

Data must be sent separately.

query = "INSERT INTO table (id, name, text) VALUES (%s, %s, %s)"
cursor.execute(query, (id, name, text))

https://dev.mysql.com/doc/connector-python/en/conn...