Copy an auto-increment value to another field

[zelig]

Is there a way to copy an auto-increment value (`id`) into another field in the same table (`org_id`)?

 

So, when someone creates a new organization, it will copy the new auto-increment value into the org_id field. Is this possible?

 

Thanks!

 

 

[chriscloyd]

create a mysql trigger

 

http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html

delimiter |


CREATE TRIGGER orgid BEFORE INSERT ON `table`

  FOR EACH ROW BEGIN

  UPDATE `table` SET org_id = NEW.id;

  END;

|

[/Code]

[btherl]

Will that trigger work being run "before insert"?