title: Insert repetitive values in sql
body: <p>Does anybody now a easier way to insert values in a table when you have a lot of repetitive values. </p>
  
  <p>I have 3 tables and for the sake of simplicity I made an zoo example out of it. One table list animals, one Zoos in USA and one which animals you can find in each zoo. </p>
  
  <p>Table: Animals</p>
  
  <pre><code>   Id   Animal
     ---------------
     1.   Elephant
     2.   Lion
     3.   Tiger
     4.   Crocodile 
     5.   Bison
     .    .... 
     .    ....
  </code></pre>
  
  <p>Table: Zoos</p>
  
  <pre><code>   Id   Zoo
     ---------------
     1.   Alaska Zoo 
     2.   Little Rock Zoo
     3.   Big Bear Alpine Zoo 
     4.   Los Angeles Zoo
     5.   Oakland Zoo
     .    .... 
     .    ....
  </code></pre>
  
  <p>Table: AnimalInZoo</p>
  
  <pre><code>   Zooid    Animalid
     -------------------
     1          1
     1          2
     1          3
     1          4 
     1          5
     2          1
     2          2
     2          3
     2          4 
     2          5
  </code></pre>
  
  <p>To insert values into the AnimalinZoo table I now write:</p>
  
  <pre><code>INSERT INTO AnimalinZoo (zooid, animals)
  VALUES (1, 1), (1, 2), (1, 3), (1, 4), (1, 5);
  
  INSERT INTO AnimalinZoo (zooid, animals)
  VALUES (2, 1),  (2, 2), (2, 3), (2, 4), (2, 5);
  </code></pre>
  
  <p>Because I would like to insert this similar list of animal in a lot of zoo, is there a easier way to write this in sql so i don't have to repeat myself so much. Or can I insert value from the animal and zoo table directly into AnimalinZoo with SQL?</p>