title: Python - How to parse and save JSON to MYSQL database
body: <p>As the title indicates, how does one use python to elegantly access an API and parse and save the JSON contents onto a relational database (MYSQL) for later access?</p>
  
  <p>Here, I saved the data onto a pandas object. But how do I create a mysql database, save the json contents onto it, and access the contents for later use?</p>
  
  <pre><code># Libraries
  import json, requests
  import pandas as pd
  from pandas.io.json import json_normalize
  
  # Set URL
  url = 'https://api-v2.themuse.com/jobs'
  
  # For loop to
  for i in range(100):
      data = json.loads(requests.get(
          url=url,
          params={'page': i}
      ).text)['results']
  
  data_norm = pd.read_json(json.dumps(data))
  </code></pre>