Trigger

[eluser]harris_priambudi[/eluser]
First I want apologize because
my question havent related from code igniter
but this my beloved forum for asking something ^_^
..
I have a question,
I need a triger
when I insert value name = batman; ( Id = auto increment )
I want to automatic insert to different table with the same value,but different coloumn name.
For Example:

I insert to user_table
id_user = ( auto increment )
name = "batman"
..
automatic insert to student_table
student_id = ( same like id_user )
student = "batman"

how can create triger mysql for that scenario?
thank you

[eluser]Otemu[/eluser]
Support for triggers is included from MySQL 5.0.2

Here is some simple example code:

Code:

CREATE TRIGGER `after_insert_name`  
        AFTER INSERT ON `trigger_after_insert_name` FOR EACH ROW  
        BEGIN  
            INSERT INTO different_name_table(id, name)  
            VALUES (NEW.id, NEW.name);  
        END

More information on triggers here