The SQL statement copies the data of two fields in the database table

This article mainly explains "SQL statement copies two field data in database table". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian to study and learn "SQL statement copies two field data in database table" together.

SQL statement to copy data for two fields in a database table

Today, I added a new field to the table, but I want to have the same value as another field in the table. Due to too much data, I want to implement it through sql statements. After testing, the following sentence is really very good.

The copy code is as follows:

update jb51_temp set B=A

jb51_temp stands for indicating that A is a field with values, B is a newly added field, remember to put the null value table in front, if set a=b, then your values are empty, it is troublesome, it is recommended to backup the database before operation.

How to copy values from one field to another

For example, there are two fields A and B,A field is the value of "I",B field value is "they", how to use update statement to copy the value of B field into A, and A combination should be placed after the original content. After updating, field A should be "we" and field B unchanged.

The copy code is as follows:

update table set A=A+B

Thank you for reading, the above is the content of "SQL statement copying two field data in database table", after learning this article, I believe everyone has a deeper understanding of SQL statement copying two field data in database table, and the specific use situation needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!