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

This article introduces the relevant knowledge of "how to connect tables to update data in PostgreSQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The update syntax for the pg join table is as follows:

The table SET field 1 = cqt that UPDATE wants to update. Field 1, field 2 = cqt. Field 2 bsm from data source table cqtWHERE the table to update. Field = cqt.bsm

Example:

Update table_p as p set p_name = a.name _ If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.