title: [sqlite3 and python]: how to fill up multiple column on a table
body: <p>I am learning database and database management with Python and I am getting crazy with a line of code to fill up multiple columns on a database from a Python interpreter.
  As you can see here 
  <a href="https://docs.python.org/2/library/sqlite3.html" rel="nofollow">https://docs.python.org/2/library/sqlite3.html</a></p>
  
  <p>when you want to fill up a column of a table from a line (say a string column) of code taken from the python interpreter the command you have to use is</p>
  
  <pre><code>c.execute('''INSERT INTO
  tableName
  (columnName) VALUES('%s')
  ''' % pythonVariable )
  </code></pre>
  
  <p>How can I fill up multiple columns with the some command? I tried in many ways such as</p>
  
  <pre><code>c.execute('''INSERT INTO
  tableName
  (columnName1, columnName2) VALUES('%s', '%s')
  ''' % pythonVariable1 pythonVariable2 )
  </code></pre>
  
  <p>or just writing the some command line two times as reported here</p>
  
  <pre><code>c.execute('''INSERT INTO
  tableName
  (columnName1) VALUES('%s')
  ''' % pythonVariable1 )
  
  c.execute('''INSERT INTO
  tableName
  (columnName2) VALUES('%s')
  ''' % pythonVariable2 )
  </code></pre>
  
  <p>But I failed with both of them and I am getting crazy with a so stupid issue, could you suggest me the right line of code, please?</p>