pymysql inserting random numbers into a column using python
<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>