title: how to specify Int in dataframe.to_sql?
body: <p>I am trying to fetch data from my database and trying to write it into another table but for some reason the dataframe.to_sql throws an error:</p>
  <pre><code>&gt; engine = create_engine(&quot;mysql+pymysql://{user}:{pw}@localhost/{db}&quot;
                         .format(user=&quot;root&quot;,
                                 pw=&quot;dhanusha&quot;,
                                 db=&quot;postmanassignment&quot;),pool_pre_ping=True)
      mycursor.execute(&quot;CREATE TABLE IF NOT EXISTS agregated( name VARCHAR(255), 
                        no_of_products INT UNSIGNED, PRIMARY KEY (name))&quot;)
     mycursor.execute(&quot;SELECT name,COUNT(id)FROM products GROUP BY name limit 10&quot;)
     result = dict(mycursor.fetchall())    
     new=pd.DataFrame(result.items(),columns=['name', 'no_of_products'])
      print(new)
     new.to_sql('agregated', con = engine,dtype={&quot;name&quot;: sqlalchemy.types.VARCHAR, &quot;no_of-products&quot;: 
     sqlalchemy.types.INT},if_exists = 'append', chunksize = 10000,index= False)
  
  
  **This gives an error:**
  
  &gt; OperationalError: (pymysql.err.OperationalError) (1054, &quot;Unknown column 'no_of_products' in 'field list'&quot;)
  </code></pre>