在尝试执行下面给出的查询时,我得到一个语法错误,我需要从表civicrm\u address更新列值,并将其从\u \u drupal\u civi\u 4\u 17数据库移动到\u drupal数据库
为了实现它,我得到了一个语法错误,错误如下
# 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'FROM abc_abc_drupal_civi_4_17.civicrm_address,abc_drupal.civic' at line 3
我该怎么修?
UPDATE abc_drupal.civicrm_address
SET abc_drupal.civicrm_address.state_province_id = abc_abc_drupal_civi_4_17.civicrm_address.state_province_id
FROM abc_abc_drupal_civi_4_17.civicrm_address,abc_drupal.civicrm_address
WHERE abc_drupal.civicrm_address.state_province_id IS NULL
AND abc_abc_drupal_civi_4_17.civicrm_address.state_province_id IS NOT NULL
AND abc_abc_drupal_civi_4_17.civicrm_address.id = abc_drupal.civicrm_address.id
AND abc_abc_drupal_civi_4_17.civicrm_address.contact_id IS NOT NULL;
2条答案
按热度按时间tzdcorbm1#
以后需要指定集合,如下所示:
vulvrdjw2#
mysql放置
JOIN
在UPDATE
条款,而不是通过单独的FROM
(the)FROM
由sql server和postgres使用)。你写的问题很难理解。我强烈建议您使用表别名,以便更容易编写和读取查询: