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` More information on triggers here |
Welcome Guest, Not a member yet? Register Sign In |