title: Java SQL 1 million rows
body: <p>I must add 1.000.000 rows in mySQL with Java, but the process is quite long․ I have this code:</p>
  
  <pre><code>for(int number=45000000;number&lt;46000000;number++){
  
  query="insert into free(number) values ("+"'"+number+"');";
  try {
      stmt.executeUpdate(query);
      System.out.println(number +" added");
  } catch (SQLException e) {
      e.printStackTrace();
  }
  </code></pre>
  
  <p>How to accelerate the process? (40 min = 100.000 rows) Any ideas? </p>