title: find and insert row to another table mysql trigger
body: <p>I have the following three tables in mysql database named "My_Company"</p>
  
  <pre><code>mysql&gt; desc employee;
  +----------+-------------+------+-----+---------+-------+
  | Field    | Type        | Null | Key | Default | Extra |
  +----------+-------------+------+-----+---------+-------+
  | Id       | int(11)     | NO   | PRI | 0       |       |
  | Emp_Name | varchar(20) | YES  |     | NULL    |       |
  | Division | varchar(20) | YES  |     | NULL    |       |
  +----------+-------------+------+-----+---------+-------+
  3 rows in set (0.00 sec)
  
  mysql&gt; desc tools;
  +-----------+-------------+------+-----+---------+-------+
  | Field     | Type        | Null | Key | Default | Extra |
  +-----------+-------------+------+-----+---------+-------+
  | Division  | varchar(20) | NO   | PRI |         |       |
  | Tool_No   | int(11)     | NO   | PRI | 0       |       |
  | Tool_Name | varchar(20) | YES  |     | NULL    |       |
  +-----------+-------------+------+-----+---------+-------+
  3 rows in set (0.01 sec)
  
  mysql&gt; desc employee_tools;
  +---------+-------------+------+-----+---------+-------+
  | Field   | Type        | Null | Key | Default | Extra |
  +---------+-------------+------+-----+---------+-------+
  | Id      | int(11)     | YES  |     | NULL    |       |
  | Tool    | varchar(20) | YES  |     | NULL    |       |
  | Status  | varchar(20) | YES  |     | NULL    |       |
  +---------+-------------+------+-----+---------+-------+
  2 rows in set (0.02 sec)
  
  -------------------------------------------------------------------------------------
  </code></pre>
  
  <p>I need to insert the rows from table tools to table employee_tools when insert a new row on table employee.</p>
  
  <p>Example, if i insert a new row to employees values as ('1','Michel','Network')
  then the the trigger should to find the tool_names of division from table tools
  and add the rows to employee_tools</p>
  
  <pre><code>mysql&gt; insert into employee values('1','Michel','Network');
  Query OK, 1 row affected (0.05 sec)
  
  mysql&gt; select * from employee;
  +----+----------+----------+
  | Id | Emp_Name | Division |
  +----+----------+----------+
  |  1 | Michel   | Network  |
  +----+----------+----------+
  1 row in set (0.00 sec)
  
  mysql&gt; select * from tools;
  +----------+---------+--------------+
  | Division | Tool_No | Tool_Name    |
  +----------+---------+--------------+
  | Network  |       1 | Crimper      |
  | Network  |       2 | LAN Tester   |
  | Network  |       3 | Sleaver      |
  | Hardware |       1 | Screw drv    |
  | Hardware |       2 | Power Tester |
  | Hardware |       3 | Plyer        |
  +----------+---------+--------------+
  3 rows in set (0.00 sec)
  
  mysql&gt; select * from employee_tools;
  +------+------------+------------+
  | Id   | Tool       |Status      |
  +------+------------+------------+
  |    1 | Crimper    |Working     |
  |    1 | LAN Tester |working     |
  |    1 | Sleaver    |working     |
  +------+------------+------------+
  3 rows in set (0.00 sec)
  </code></pre>
  
  <p>the status will be updated manually like below...</p>
  
  <pre><code>+------+------------+------------+
  | Id   | Tool       |Status      |
  +------+------------+------------+
  |    1 | Crimper    |Working     |
  |    1 | LAN Tester |Not working |
  |    1 | Sleaver    |Broken      |
  +------+------------+------------+
  </code></pre>