INSERT ... SELECT Syntax

[vieyang]

how can I make a "INSERT ... SELECT Syntax",

For example:

INSERT INTO tbl_temp2 (fld_id)
  SELECT tbl_temp1.fld_order_id
  FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

the doc is https://dev.mysql.com/doc/refman/8.0/en/insert-select.html