Mysqlite commands in Python

1.IMPORT SQL LITE AND CREATE DB

import sqlite3
conn = sqlite3.connect('test.db') #create db or connect if already exist

2. CREATE TABLE

conn.execute('''CREATE TABLE questions
         (id INTEGER PRIMARY KEY NOT NULL,
         question_url    TEXT NOT NULL,
         status            INTEGER     NOT NULL DEFAULT 0,
         Upvotes        INTEGER,
         downvotes        INTEGER);''')

3.INSERT RECORDS

conn.execute("INSERT INTO questions (question_url,status,Upvotes,downvotes) \
      VALUES ('https://status.com', 0, 0, 0 )");
conn.commit()

4.SELECT DATA

cursor = conn.execute("SELECT id, question_url, status, Upvotes, downvotes from questions")
for row in cursor:
   print "ID = ", row[0]
   print "question_url = ", row[1]
   print "status = ", row[2]
   print "Upvotes = ", row[3], "\n"

5.UPDATE DATA 

conn.execute("UPDATE questions set status = 25 where ID = 1")
conn.commit()

6. DELETE DATA

conn.execute("DELETE from questions where ID = 2;")
conn.commit()

7. CLOSE THE CONNECTION

conn.close()