MySQL updates a field in a table to be equal to the value of a field in another table

MySQL updates a field in a table to be equal to the value of a field in another table

As shown below:

update table1 as z left join table2 as zb on z.zcatId = zb.zcatId set z.zcatName = zb.zcatName where z.zcatName is null;

The above MySQL update field in a table equal to the value of a field in another table is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

You may also be interested in:
  • Sql query MySql database table name and description table field (column) information
  • How to get the field list after querying the results of the Python module pymysql
  • Summary of MySQL's commonly used SQL statements for creating tables, adding fields, modifying fields, and adding indexes
  • How to add fields to a large data table in MySQL
  • How to modify a MySQL table to add multiple columns (fields) and indexes at one time
  • MySql creates a table with explanation and annotates the table and fields
  • MySQL uses the select statement to query the data of the specified column (field) in the specified table
  • Mysql determines whether a table field or index exists
  • Delete a field in the MySQL table from the command line
  • Add a field to the table in the MySQL command line (field name, whether it is empty, default value)
  • Basic tutorial on using table aliases and field aliases in MySQL
  • How to use a field in one table to update a field in another table in MySQL

<<:  The JS hasOwnProperty() method detects whether a property is an object's own property.

>>:  Linux confirms that the data disk has been uninstalled and a new custom image can be created

Recommend

Example code for implementing photo stacking effect with CSS

Achieve results step 1. Initial index.html To bui...

MariaDB under Linux starts with the root user (recommended)

Recently, due to the need to test security produc...

Detailed explanation of MySQL Group by optimization

Table of contents Standard execution process opti...

Step by step guide to build a calendar component with React

Table of contents Business Background Using Techn...

Comprehensive inventory of important log files in MySQL

Table of contents Introduction Log classification...

Two ideas for implementing database horizontal segmentation

introduction With the widespread popularity of In...

A brief discussion on the role and working principle of key in Vue3

What is the function of this key attribute? Let’s...

Mobile development tutorial: Summary of pixel display issues

Preface I believe that in the process of mobile t...

MySQL import and export backup details

Table of contents 1. Detailed explanation of MySQ...

Analysis and summary of the impact of MySQL transactions on efficiency

1. Database transactions will reduce database per...

Solution for applying CSS3 transforms to background images

CSS transformations, while cool, have not yet bee...

How to create a Docker repository using Nexus

The warehouse created using the official Docker R...

Rules for registration form design

I finished reading "Patterns for Sign Up &...

Tomcat8 uses cronolog to split Catalina.Out logs

background If the catalina.out log file generated...

How to build a standardized vmware image for kubernetes under rancher

When learning kubernetes, we need to practice in ...