Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use the update statement to associate multiple tables? I hope you will learn a lot after reading this article. Let's discuss it together.

How to use the update statement to associate multiple tables?

The method of associating multiple tables in update statements:

1) the simplest form

SQL code

-- it has been confirmed that all customer_id less than 1000 in the customers table are 'Beijing'.

-- less than 1000 are all old customers in the city before the company went nationwide:) update customersset city_name=' Beijing 'where customer_id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.