Sql
Copy Code code as follows:
INSERT into ' table ' (' id ', ' aa ', ' BB ', ' cc ') SELECT ' id ', ' aa ', ' BB ', ' cc ' from ' table ' (WHERE ...)
Tips:
Copy Code code as follows:
/**
* When you copy a new record, you may want to update the ID or part of the data (assuming ID is incremented)
*
* TEXT_AA is a fixed value, you can assign the value of a variable in a script call such as ($AA)
* Note the difference between ' Text_aa ' and ' cc ', one is the data, the other is the field
**/
INSERT into ' table ' (' id ', ' aa ', ' BB ', ' cc ') SELECT ', ' AA content ', ' bb note cc symbol difference ', ' cc ' from ' table ' (WHERE ...)
/**
* CONCAT (' BB ', ' Additional information-copy ')
* On the basis of the extraction of the original data, add additional information (see Windwos under the xxxx.xxx understand)
**/
INSERT into ' table ' (' id ', ' aa ', ' BB ', ' cc ') SELECT ', ' AA content ', CONCAT (' BB ', ' Additional information-copy '), ' cc ' from ' table ' (WHERE ...)
