MySQL field to copy table fields to other tables

Sometimes we need to copy the entire column of data from one field to another in a new field, which is simple enough for SQL to write:

UPDATE tb_1 SET content_target = Content_source;

The approximate wording is as follows: Name Shi Casino

Update {your_table} set {Source_field} = {Object_field} WHERE cause

Have Navicat and other tools better, you can directly select a column of data, copy and paste into the column you want. If it's the same table that's fine, if it's a new table, keep their number of rows consistent. If the number of rows is inconsistent, you can create a new table and copy the columns so that the number of IDs remains the same.

Sometimes these MySQL interface tools will error, this time with the command line better. For example, you can copy a table field data to a different list of fields, so write:

UPDATE tb_1 INNER JOIN tb_2 on tb_1.tid = Tb_2.tidset tb_1.tcontent = tb_2.tcontent

The following is a practical example of writing a link to a phpcms generated static page to the URL field in the Phpcms_content table:

Let's put together the required URL field columns.

SELECT CONCAT (From_unixtime (inputtime, '%y/%m%d '), '/', ContentID, '. html ') as DT from Phpcms_content ORDER by ContentID DE Sc

Then, in the Query Editor (navicat), copy the entire segment to the URL column in the Phpcms_content table.

MySQL field to copy table fields to other tables