title: How to insert only one value into sqlite3 table as an variable while inserting null to every else column
body: <p>I want to modify the code beneath so that I only insert <code>input</code> variable to the table. All other columns should store <code>NULL</code> value. I think the most obvious solution would be to declare that <code>column2 = NULL</code> and <code>column3 = NULL</code>, but I was thinking is there another way?</p>
  <pre><code>import sqlite3
  
  column1 = input()
  
  sqliteConnection = sqlite3.connect('database.db')
  cursor = sqliteConnection.cursor()
  
  sqlite_insert_with_param = &quot;INSERT INTO ideas (column1, column2, column3) VALUES (?, ?, ?);&quot; #column1 is primary key
  
  data_tuple = (column1, column2, column3)
  cursor.execute(sqlite_insert_with_param, data_tuple)
  sqliteConnection.commit()
  
  cursor.close()
  </code></pre>
  <p>Eventually I want this to work in Tkinter app that prompts user input for column 1 with <code>Entry</code>-widget and it would create the database entry without any other information on it other than the primary key.</p>