你可以使用:

UPDATE Station AS st1, StationOld AS st2
   SET st1.already_used = 1
 WHERE st1.code = st2.code

您可以像这样使用内部连接从另一个表更新值

UPDATE [table1_name] AS t1 INNER JOIN [table2_name] AS t2 ON t1.column1_name] = t2.[column1_name] SET t1.[column2_name] = t2.column2_name];

跟随这里了解如何使用这个查询http://www.voidtricks.com/mysql-inner-join-update/

或者您可以使用select作为子查询来完成此操作

UPDATE [table_name] SET [column_name] = (SELECT [column_name] FROM [table_name] WHERE [column_name] = [value]) WHERE [column_name] = [value];

查询详情请参见http://www.voidtricks.com/mysql-update-from-select/

你可以使用:

UPDATE Station AS st1, StationOld AS st2
   SET st1.already_used = 1
 WHERE st1.code = st2.code

对于同一张表，

UPDATE PHA_BILL_SEGMENT AS PHA,
     (SELECT BILL_ID, COUNT(REGISTRATION_NUMBER) AS REG 
       FROM PHA_BILL_SEGMENT
        GROUP BY REGISTRATION_NUMBER, BILL_DATE, BILL_AMOUNT
        HAVING REG > 1) T
    SET PHA.BILL_DATE = PHA.BILL_DATE + 2
 WHERE PHA.BILL_ID = T.BILL_ID;

INSERT INTO all_table
SELECT Orders.OrderID,
    Orders.CustomerID,
    Orders.Amount,
    Orders.ProductID,
    Orders.Date,
    Customer.CustomerName,
    Customer.Address
FROM Orders
JOIN Customer ON Orders.CustomerID=Customer.CustomerID
WHERE Orders.OrderID not in (SELECT OrderID FROM all_table)

如果有人试图将数据从一个数据库更新到另一个数据库，而不管他们的目标是哪个表，那么必须有一些标准来做到这一点。

这个对所有关卡来说都更好更干净:

UPDATE dbname1.content targetTable

LEFT JOIN dbname2.someothertable sourceTable ON
    targetTable.compare_field= sourceTable.compare_field
SET
    targetTable.col1  = sourceTable.cola,
    targetTable.col2 = sourceTable.colb, 
    targetTable.col3 = sourceTable.colc, 
    targetTable.col4 = sourceTable.cold 

Traaa !效果很好!

有了以上的理解，您就可以修改设置的字段和“on”标准来完成您的工作。您还可以执行检查，然后将数据拉入临时表，然后使用替换表和列名的上述语法运行更新。

希望有用，如果不行请告诉我。我会为你写一个精确的查询。