在此之前我读过各种帖子。但是他们似乎都没有为我工作。
正如标题所示,我试图从另一个表中的列更新一列。之前我不记得有问题
1.表:user_settings.contact_id,我想用contacts.id更新其中(user_settings.account_id == contacts_account_id)
2.以前的联系人通过account_id链接到用户帐户。但是,现在我们要通过contacts.id将联系人链接到user_settings
以下是我尝试过的几个例子,尽管他们都没有工作。我会感兴趣的是A.)为什么他们不工作和B.)我该怎么办?
示例A:
UPDATE user_settings
SET user_settings.contact_id = contacts.id
FROM user_settings
INNER JOIN contacts ON user_settings.account_id = contacts.account_id
实施例B:
UPDATE (SELECT A.contact_id id1, B.id id2
FROM user_settings A, contacts B
WHERE user_settings.account_id = contacts.account_id)
SET id1 = id2
示例C:
UPDATE user_settings
SET user_settings.contact_id = (SELECT id
FROM contacts
WHERE (user_settings.account_id = contacts.account_id)
WHERE EXISTS ( user_settings.account_id = contacts.account_id )
我觉得我的大脑只是关闭我,并会感到任何颠簸重新启动它。谢谢 :)