title: executing native SQL to Mysql in Python
body: <p>I want to execute this statement in the mysql database. But I can't get the format right. The ? is replacing a table name not a value. I have tried to concatenate the string together also but the same result.</p>
  
  <p>Tried executing the same insert that I do from Mysql workbench without problems. But still won't work</p>
  
  <pre><code>mysql.connector.errors.DataError: 1136 (21S01): Column count doesn't match value count at row 1
  
  import mysql.connector    
  for table in tables:
      sql = """insert into close_price
      select * from nn_indexes_20180105
      where identifier = 'OMXS30'
      and seconds_offs = (select max(seconds_offs) as seconds_offs 
      from nn_indexes_20180105 
      where seconds_offs &lt;= 55800
      and identifier = 'OMXS30');"""
  </code></pre>