Python数据从美丽的汤表插入到MYSQL

I am trying to insert data into a MYSQL table from a html table using beautiful soup written in python. Currently I was able to do this by creating an interim csv file but it does not seems to work in Linux and seems inefficient. Below is my code that works with the CSV, which is the portion I will like to elimnate.I am trying to insert data into a MYSQL table f