title: insert rows in a table with value in a column that is different for each row inserted
body: <p>I have tables like this:</p>
  
  <pre><code>CREATE TABLE test(id INT,product_id INT,sent_at datetime);
  CREATE TABLE products(id INT);
  </code></pre>
  
  <p>I want to create a query like this:</p>
  
  <pre><code>INSERT INTO test(product_id,sent_at)
      SELECT products.id as product_id,
      DATE_ADD(NOW(),INTERVAL 10 MINUTE) as sent_at
      FROM products;
  </code></pre>
  
  <p>I have 1000 rows in the <code>products</code> table and I want a different value for the <code>sent_at</code> column for each of the rows in the <code>test</code> table.
  The <code>sent_at</code> column should be increment by 10 more minutes for each row of the <code>products</code> table inserted.
  I don't want the same value for <code>sent_at</code> column for all the rows in <code>test</code> table.</p>
  
  <p>AND I CANNOT use a procedure. I am using MySQL 5.7. </p>
  
  <p>Please help me. thanks in advance.</p>