title: Beautiful soup webscrape into mysql
body: <p>The code so far downloads and prints onto the screen,but how do I get that printed material into a sql database.If I wanted to get the data into CSV files it seems that Python(on a good day) creates the file automatically.Obviously with transferring into mySql I assume that I would have to create a database beforehand in order to receive the data.My question is how would I get the data from the scrape into the database omitting the csv step altogether.
  In anticipation I have already downloaded pyMySql library.Any suggestions much aprreciated..looknow</p>
  
  <pre><code>from urllib import urlopen
  from bs4 import BeautifulSoup
  html = urlopen("http://www.officialcharts.com/charts/singles-      chart/19800203/7501/" )
  
   bsObj = BeautifulSoup(html)
   nameList = bsObj. findAll("div" , {"class" : "artist",})
   for name in nameList:
   print(name. get_text())
  
   html = urlopen("http://www.officialcharts.com/charts/singles-    chart/19800203/7501/" )
   bsObj = BeautifulSoup(html)
   nameList = bsObj. findAll("div" , {"class" : "title"})
   for name in nameList:
   print(name. get_text())     
  </code></pre>