宜搭update多表关联修改

网站编辑2023-05-30 13:55:42827

您好!如果您想更新多个表的数据,您可以按照以下步骤进行操作:

1. 从当前数据表中选择需要更新的数据,然后在菜单栏中选择 "Update by your table"。 2. 在更新列表中选择要更新的数据,并将其拖动到"Select by table"菜单中。在弹出的菜单中,选择"Insert by your id"选项。 3. 在更新列表中选择要插入新数据的表。 4. 在 "Insert by your id " 下拉列表中选择需要插入新数据的所有列。例如,如果您需要更新"SELECT * FROM your table"表,则可以选择"SELECT id, name, SUM(VARCHAR() WHERE id IN (SELECT type, name, SUM(VARCHAR() WHERE name IN (SELECT name, SUM(VARCHAR() WHERE name IN (SELECT id, SUM(VARCHAR() WHERE name, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR()) WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age WHERE age) IN (SELECT name, SUM(VARCHAR() WHERE name, SUM(VARCHAR())) IN (SELECT id, name, SUM(VARCHAR() WHERE name IN (SELECT name, SUM(VARCHAR() WHERE name, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age WHERE age) IN (SELECT name, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age WHERE age)) IN (SELECT name, SUM(VARCHAR() WHERE age IN (SELECT name, SUM(VARCHAR() WHERE age) IN (SELECT name, SUM(VARCHAR() WHERE age IN (SELECT id, SUM(VARCHAR() WHERE age WHOERE age) IN (SELECT id, SUM(VARCHAR() WHOERE age) IN (SELECT name, SUM(VARCHAR() WHOERE age) IN (SELECT your id, your symbol, your id, your name) IN (SELECT name, SUM(VARCHAR() WHOERE your name) IN (SELECT name,. your symbol )))", Insert Frames ('/' ) 5. 点击下一步,提示您输入您更新的表的所有列的名字。输入名字后,点击"Insert by your id to selected fields"。 6. 将所有需要插入新列的列添加到