title: SQL insert multiple data in a specific column (python)
body: <p>Hi have the following code:</p>
  
  <pre><code>def create_table():
      c.execute('CREATE TABLE IF NOT EXISTS TEST(Tournament TEXT, MATCH_TIME TEXT, TEAM_1 TEXT, TEAM_2 TEXT)')
  
  create_table()
  
  
  def data_entry_tournament():
      c.executemany("INSERT INTO TEST(TOURNAMENT) VALUES (?)",
          (Tournament.text.strip()))
      conn.commit()
  def data_entry_Time_Event():
      c.executemany("INSERT INTO TEST(MATCH_TIME) VALUES (?)",
          (Time_Event.text.strip()))
      conn.commit()
  def data_entry_TEAM_1():
      c.executemany("INSERT INTO TEST(TEAM_1) VALUES (?)",
          (Team_1.text.strip()))
      conn.commit()
  def data_entry_TEAM_2():
      c.executemany("INSERT INTO TEST(TEAM_2) VALUES (?)",
          (Team_2.text.strip()))
      conn.commit()
  
          driver.get(link)
  
          Tournament = driver.find_element_by_css_selector("h2[class='sport-title']")
          if Tournament.text is not "":
              data_entry_tournament()
          for row in driver.find_elements_by_css_selector("tbody[class='ng-scope']"):
              Time_Event = row.find_elements_by_tag_name("td")[0]
              Team_1 = row.find_elements_by_tag_name("td")[1]
              Team_2 = row.find_elements_by_tag_name("td")[7]
              if Time_Event.text is not "":
                  data_entry_Time_Event()
              if Team_1.text is not "":
                  data_entry_TEAM_1()
              if Team_1_odds.text is not "":
                  data_entry_TEAM_1_ODD()
              if Team_2.text is not "":
                  data_entry_TEAM_2()
  
  c.close()
  conn.close()
  </code></pre>
  
  <p>My problem is that the output inside SQL is totally wrong, for every row there is only one character and the text is in vertical (and split it in every column in different row).</p>
  
  <p>What i would like to have is the following table for example:</p>
  
  <p><strong>TOURNAMENT | MATCH_TIME | TEAM_1 | TEAM_2</strong></p>
  
  <p>EURO 2016 | 18:00 | SPAIN | ITALY</p>
  
  <p>EURO 2016 | 12:00 | HUNGARY | PORTUGAL</p>
  
  <p>and so on...</p>
  
  <p>I'm new in python and sql so I'm sorry if the above code is really bad.</p>
  
  <p>How can i solve the problem and display everything correctly?
  Is there a better and faster method than what I wrote above, to achieve the same result?</p>
  
  <p>Thanks a lot!!!</p>