enter the order number on the page to query the data in Table A, extract some of the field values in Table A to the page, and make changes. The other field values remain the same.
insert the modified value and the unmodified field into the new table b. The table structure of Table An and Table B is similar but not exactly the same. The main question now is: how do you insert both the modified fields and the unmodified fields into Table B? (the number of columns in the two tables is very large, more than 200 columns)
requirements:
1. The data modified on the page is only used by Table B, and Table An is not modified.
2. Add a modified record field (as the primary key) in Table B in the format of the original order number + number. The structure of the two tables is shown in the figure below, but only part of the screenshot is taken as an example. in fact, the columns of both tables have hundreds of columns. There are about seven or eight values modified on the page.
