about auto increment

[varunkrish]

i hav doubt in sql.we having two tables one parent and child tables .in parent table we having the field stud_id primary key auto increament .if insert any data to the parent table to this id the value to be also insert in the child table. in child table the stud_id is used as foreign key.give the query.

[skhanal]

You need to write an insert trigger on parent table to insert corresponding row in the child table.