title: MYSQL Insert Trigger (Insert Multiple values)
body: <p>I have a use case</p>
  
  <p>Table 1 has data as below</p>
  
  <pre><code>**CID**  **COMPANY**
    1      CompanyA
    2      CompanyB
    3      CompanyC
  </code></pre>
  
  <p>Table 2 has data as below</p>
  
  <pre><code>  **ID****COMPANY****PERSON**
      1  CompanyB  Sachin
      2  CompanyB  Kohli
      3  CompanyC  Dhoni
      4  CompanyA  Raina
      5  CompanyA  Shikar
  </code></pre>
  
  <p>data should be inserted in Table 3 , whenever an insert occurs in table 1, i need to select values from Table 2 based on COMPANY and insert the data into table 3 as follows</p>
  
  <p>Table 3</p>
  
  <pre><code> **ID****CID****PERSON**
      1    1    Raina    
      2    1    Shikar
      3    2    Sachin
      4    2    Kohli
      5    3    Dhoni
  </code></pre>