title: ProgrammingError: 1054 (42S22): Unknown column 'Lucas_Johnson' in 'field list'
body: <p>I am trying to insert into a MySQL database and it is giving me the error:</p>
  
  <pre><code>ProgrammingError: 1054 (42S22): Unknown column 'Lucas_Johnson' in 'field list'
  </code></pre>
  
  <p>The command is:</p>
  
  <pre><code>c.execute("INSERT INTO master (ID, Name, Location, DateTime, Status, flagged) VALUES("+str(id)+","+str(name)+","+place+","+date.replace(':','-').replace(' ', '_')+", 'Out', "+str(flagged)+")")
  </code></pre>