Python & SQLlite

import sqlite3

import requests

from bs4 import BeautifulSoup

url = 'http://www.lotto-8.com/listltohk.asp'

res = requests.get(url)

soup = BeautifulSoup(res.text, 'html.parser')

conn = sqlite3.connect('/Users/jenyihua/Desktop/Mark_Six.db')

c = conn.cursor()

for i in soup.find_all('tr', style = 'text-align:center; background-color: #CCEEFF;'):

    text = i.text.split('\n')

    text.pop(0)

    text.pop(-1)

    text.pop(-1)

    text.pop(-1)

    text[1] = text[1].replace('\xa0','')

    num1 = text[1].split(',')[0]

    num2 = text[1].split(',')[1]

    num3 = text[1].split(',')[2]

    num4 = text[1].split(',')[3]

    num5 = text[1].split(',')[4]

    num6 = text[1].split(',')[5]

    c.execute('insert into mark_six(data, num1, num2, num3, num4, num5, num6) values (?, ?, ?, ?, ?, ?, ?)',[text[0], num1, num2, num3, num4, num5, num6])

    conn.commit()

    print(text[0], num1, num2, num3, num4, num5, num6)