I have a users table that has a one to one relationship to a user_preferences table (primary foreign key user_id). When a new row is added to the users table (new id added), is there a way to setup the relationship between the users_preferences table so that a row with the new user id is also added to it?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Calling this a way to "setup the relationship" isn't quite technically accurate, but you can do this with an
Triggers that execute more than one statement require you to temporarily change the