KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have three tables: contacts, domains, and contacts_domains, which form a many-to-many relationship. I would like to run a query that updates the contacts_domains table, but only for domains that have exactly one contact. I know how to SELECT the rows I'm interested in, but not how to UPDATE them. SELECT domain_id, contact_id, dominant FROM contacts_domains GROUP BY domain_id HAVING COUNT(contact_id) = 1 I want to set contacts_domains.dominant = 1 for all these results. Thanks!
Tags (comma-separated)
Save Edits
Cancel