How to insert multiple rows for a unique ID
<p>I'm trying to achieve this insert as a result in DB:</p>

<pre><code>USER ID    SERVICE  OPERATION

2681    6        47
2681    6        48
2681    6        95
2681    6        104
2681    12       106
2681    12       116
</code></pre>

<p>for 3000 unique user id's where second and third column data are the same for every user id.</p>

<p>I could do </p>

<pre><code>INSERT INTO table (user, service, operation)
   VALUES ('2681', '6', '47'); ('2681', '6', '48'); etc..
</code></pre>

<p>and repeat this for 18000 rows.</p>

<p>Is there a more simple way to do this?</p>