Jul-29-2021, 12:18 PM
ndc85430 made me think.
Normally, I don't worry about security much, I only run a little homework webpage, no important data at all. Nothing to steal, and everything backed-up on my laptop and only me issuing such select queries.
But I suppose it is wise to consider security. I found this page about parameterized queries. Looks
a. understandable and
b. fairly easy
This advice is for mysql.connector
Not sure if that will work with pymysql, which I use. I'll try tomorrow.
Something new I learned!!
Normally, I don't worry about security much, I only run a little homework webpage, no important data at all. Nothing to steal, and everything backed-up on my laptop and only me issuing such select queries.
But I suppose it is wise to consider security. I found this page about parameterized queries. Looks
a. understandable and
b. fairly easy
This advice is for mysql.connector
Not sure if that will work with pymysql, which I use. I'll try tomorrow.
Something new I learned!!