SQL
CopyCodeThe Code is as follows: insert into 'table' ('id', 'AA', 'bb ', 'cc') Select 'id', 'AA', 'bb ', 'cc' from 'table' (where .....)
TIPS:Copy codeThe Code is as follows :/**
* When copying a new record, you may need to update the ID or part of the data (assuming that the ID is automatically increased)
*
* Text_aa is a fixed value. You can assign a variable value in a script call, for example, $ AA)
* Note the difference between 'text _ AA' and 'cc'. One is data and the other is field.
**/
Insert into 'table' ('id', 'AA', 'bb ', 'cc') select', 'aa content', 'bb pay attention to CC symbol Difference ', 'cc' from 'table' (where .....)
/**
* Concat ('bb', 'additional information-copy ')
* Add additional information on the basis of extracting the original data (which is understandable when I have seen XXX. XXX in windwos)
**/
Insert into 'table' ('id', 'A', 'bb ', 'cc') select', 'aa content', Concat ('bb ', 'additional information-copy'), 'cc' from 'table' (where .....)