title: How do I insert multiple rows int MySQL where the values of one column are from a single list of values and the others are constant
body: <p>I'm using MariaDB 10.4. I have a list of values, i.e. <code>one@email.com</code>, <code>two@email.com</code>, and <code>three@email.com</code> (my actual list is much longer).</p>
  
  <p>I would like to make an SQL insert equivalent to the following:</p>
  
  <pre><code>insert into my_table(email, foreign_key_id, timestamp) values
  ('one@email.com', 1, now()),
  ('two@email.com', 1, now()),
  ('three@email.com', 1, now());
  </code></pre>
  
  <p>While only having to write something like <code>select email from ('one@email.com', 'two@email.com', and 'three@email.com')</code> somewhere in the insert query without duplicating the constants/functions on each line. Can I do this in SQL without any temporary tables?</p>