current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

How do I create a one-to-one relationship using existing columns in MySQL Workbench?

I have an EER diagram tab open and I am selecting from the toolbar on the left hand side.

Unfortunately it seems that I can create a one-to-many or many-to-one relationship but not a one-to-one.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted
  • Right click on the relationship line
  • Select 'Edit Relationship'
  • Click on the Foreign Key tab in the Relationship Tab
  • The Cardinality of the relationship can be changed with the two radio buttons
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.