MySQL and MsSQL multi-Table update

MySQL and MsSQL multi-Table update assume that we have two data tables, one of which stores Product data for the Product table, among them, there are product quota Price and a quota of the company's quota for the CompanyId;
Another example table is the Company table, which stores the basic information of the Company, including the region Region region Area, now, we want to bring down all the products in our products, such as those in the South region, by 10% in Mysql.

UPDATE product p inner join Company c ON p. companyId = c. companyIdSET p. price = p. price * 0.9 WHERE c. area = 'south' in SQL Server, we can UPDATE [p] SET [price] = [price] * 0.9 FROM [Product] AS [p] INNER JOIN [dbo ]. [Company] AS [c] ON [p]. companyId = [c]. companyIdWHERE [c]. [Area] = 'south'