MySQL Trigger to insert a new record in another table

[Pulsorock]

Hi!

I have two tables (ie: posts and posts_details). Each one of them has a primary key of post_id (along with others data columns on each table).

I need a way that when a new record is inserted in the posts table, a new record is inserted automatically to the posts_details table with the same value of the post_id that was previously inserted in the posts table.

Ideas?

Thanks!

[Pulsorock]

I believe this did the work:

CREATE TRIGGER `create_post_details` AFTER INSERT ON `posts` 
    FOR EACH ROW BEGIN
    INSERT INTO `posts_details` SET post_id = NEW.post_id;
    END;