title: pymysql inserting random numbers into a column using python
body: <p>I want to insert random numbers to a MySQL column <code>rnd_value</code> with 100 random numbers including and between 1 to 100 using python.</p>
  
  <p>I will generate random numbers from python using </p>
  
  <pre><code>random.randrange(1,100)
  </code></pre>
  
  <p>I have added MYSQL query to the database </p>
  
  <pre><code> CREATE SCHEMA `random_values` ;
  CREATE TABLE `exercise`.`random_values` (
    `id` INT NOT NULL AUTO_INCREMENT COMMENT '',
    `rnd_value` INT NULL COMMENT '',
    PRIMARY KEY (`id`)  COMMENT '');
  </code></pre>
  
  <p>I use pymysql connector to insert data into MySQL database. Can anyone suggest me to how to insert these random numbers into a MySQL column using python?</p>