MySQL Insert insert new form, no need to splice multiple inserts

Note that you cannot omit any of the fields in the table. Include self-increment ID

The principle is "table interpolation table"

INSERT  intoprod_attrSelectA.*  from (        SELECT                     5                    asprod_id,1                    asattr_id,'China Press'          asAttr_valueUNION        SELECT                     5                    asprod_id,2                    asattr_id,'Tsinghua Press'          asattr_value) asA

Table structure

MySQL Insert insert new form, no need to splice multiple inserts