title: python to mysql (MariaDB) insert query with variable error
body: <p>I am trying use insert query to write to a MariaDB database using Python(3.6). </p>
  
  <p>I am able to successfully connect to the database but insert query with variable doesn't seem to work. But, when I use insert query directly inside .execute() without variable, it seems to work. </p>
  
  <pre><code>script = "insert INTO Table1 (Column1) VALUES (%s)"
  val=("911")
  mycursor.execute(script,val)
  </code></pre>
  
  <p>I am getting following programming error for above code:</p>
  
  <p>ProgrammingError: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s)' at line 1</p>
  
  <p>Any pointers in right direction would be appreciated.</p>