Re: Can I create a trigger to add another record based on the inserted record in the same table?

On Jul 17, 2012, at 20:59, Mohd Shaiza Ibrahim <mohdshaiza(at)gmail(dot)com> wrote:

> Hi,
>
> Can you guys please help me? My question sounds like this.
>
> When I insert a new record in a table, can I create a trigger to add
> another record based on the inserted record in the same table?
>
> For example,
>
> INSERT INTO employee (emp_id, emp_name) VALUES (0001, 'Jack');
>
> The result:
>
> Select * from employee;
>
> emp_id | emp_name
> 0001 | Jack
> 0002 | Bob
>
> I've tried running the statement below but it doesn't work. Infinite
> loop i'm guessing.
>
>

Infinite loop is correct. You need to fix your logic to solve that problem or consider a new design. Maybe restrict inserts to the table to a security definer function and put you dual insert logic into it.

David J.