Mysql insert update statement

When the mysql insert update statement runs this statement, it automatically determines whether there is a duplicate primary key in the database with the record you want to insert. If yes, it is updated. If not, the insert format is as follows: insert into tablename (Field 1, Field 2) select * from (select? Field 1 ,? Field 2 ,.... from dual) as B on duplicate key update field 1 = B. field 1 ,.... example of www.2cto.com: insert into trtb_dim_top_cats (cid, parent_cid, name, is_parent, status, sort_order, lev) select * from (select? Cid ,? Parent_cid ,? Name ,? Is_parent ,? Status ,? Sort_order ,?
Levfrom dual) as B on duplicate key update cid = B. cid, parent_cid = B. parent_cid, name = B. name, is_parent = B. is_parent, status = B. status,
Sort_order = B. sort_order, column = B. Column