title: how to insert values into an amazon rds using python boto
body: <p>I am trying to get common prefixes from an amazon s3 bucketthrough python</p>
  
  <pre><code>import boto3
  
  s3 = boto3.resource('s3')
  bucket = s3.Bucket('my-bucket')
  result = bucket.meta.client.list_objects(Bucket=bucket.name, Delimiter='/')
  for o in result.get('CommonPrefixes'):
      print(o.get('Prefix'))
  </code></pre>
  
  <p>and now I want to insert these prefixes into an Amazon RDS MySQL database. I have a table bucket in which there are column <code>bucket_id</code> , <code>prefixes</code>. I want to store this result into the database inside the bucket table:</p>
  
  <pre><code>username:&lt;myusername&gt;
  password:&lt;mypassword&gt;
   url :environment-instance.cg3tbe50l9yn.us-east-1.rds.amazonaws.com:3306
  
  database:&lt;my-database&gt;
  tablename:&lt;bucket&gt;
  columnName:&lt;name&gt;
  </code></pre>