Skip to content

Tag: pymysql

How to read JSON value in MySQL

The JSON output I need to insert into my database but my source code throws an error: The source code: Can anyone help me with this, as I need to get values for open, close, high and low. error: Answer you have 5 columns, hence 5 bind variables. Your insert template is over complicated with any database opera…

SQL wildcards in PYMYSQL search

I am struggling to put together a simple SQL wildcard search for my Flask application. I am using an HTML form field to run a simple mysql query “WHERE CustomerName LIKE ‘a%’”- https://www.w3schools.com/sql/sql_wildcards.asp – However I am unable to get the right positioning for the se…