title: How to the store a column from a SQL request into a variable?
body: <p>I want to put the result of each column of the result of my request and store them into separate variables, so I can exploit its results.</p>
  <p>I precise this is with a SELECt * and not separate requests.</p>
  <p>So, If I do for example:</p>
  <pre><code>with connection.cursor() as cursor:
      # Read a single record
      sql = 'SELECT * FROM table'
      cursor.execute(sql)
      result = cursor.fetchall()
      print(result)
  </code></pre>
  <p>I want to do :</p>
  <p>a = [results from column1]
  b = [results from column2]</p>
  <p>The results should be turned into a row and not be left as a column, to make it a dictionary.</p>
  <p>It's probably very simple but I'm new with Python / SQL, thank you.</p>