title: Inserting an array into sqlite3 python
body: <p>I have a list/array of strings:</p>
  
  <pre><code>l = ['jack','jill','bob']
  </code></pre>
  
  <p>Now I need to create a table in slite3 for python using which I can insert this array into a column called "Names". I do not want multiple rows with each name in each row. I want a single row which contains the array exactly as shown above and I want to be able to retrieve it in exactly the same format. How can I insert an array as an element in a db? What am I supposed to declare as the data type of the array while creating the db itself? Like:</p>
  
  <pre><code>c.execute("CREATE TABLE names(id text, names ??)")
  </code></pre>
  
  <p>How do I insert values too? Like:</p>
  
  <pre><code>c.execute("INSERT INTO names VALUES(?,?)",(id,l))
  </code></pre>
  
  <p>EDIT: I am being so foolish. I just realized that I can have multiple entries for the id and use a query to extract all relevant names. Thanks anyway!</p>