title: pyodbc - where to insert data?
body: <p>I'm having some trouble inserting data using pyodbc. I have my microsoft server details which I've added to the code: </p>
  
  <pre><code>cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=INSERT IP NUMBER;DATABASE=INSERT DATABASE NAME;UID=INSERT USER NAME;PWD=INSERT PASSWORD')
  </code></pre>
  
  <p>I can connect to the server, however I'm not sure how to write to the table I've created. I have the following details:</p>
  
  <p>variable_cars = "mercedes", "audi", "ferrari" </p>
  
  <p>A table on the database called "tester."</p>
  
  <p>And a column in the table called "car_brands" </p>
  
  <p>I would I go about adding the "variable_cars" list to the column "car_brands" on the table? I tried this but it didn't work:</p>
  
  <pre><code>cursor.execute("insert into (tester, name) values ('car_brands', 'variable_cars')")
  </code></pre>
  
  <p>Does anyone know how I can do this? </p>