Copy and insert method for entire record in MySQL

From MSSQL to export an article table, need to insert into the PHPCMS content table phpcms_content, need to do the article can be published to different columns. That is, you need to copy a record and modify its CATID, and then insert it at the end of the table.

The code is as follows	Copy Code
INSERT into Phpcms_content (SELECT). $r [$i] [' aid ']. "+ 520,". $r [$i] [' Cateid ']. ", News_catid, CATID, typeID, Areaid, title , style, thumb, keywords, keywords, posids, url, listorder, status, UserID, username, inputtime, updatetime, Searchid, ISL Ink, prefix from phpcms_content WHERE ContentID = ' ". $r [$i -1][' aid ']."

Is roughly: INSERT into a SELECT id+1, ... (Other fields) from A;

The following PHP specific program:

The code is as follows

Copy Code

$query = "SELECT * from Articleincategory order by ArticleID"; $result = $connector-> query ($query); $i = 0; while ($myrow = $connector-> fetch_array ($result)) { $r [$i] [' aid '] = $myrow ["ArticleID"]; $r [$i] [' cateid '] = $myrow ["CategoryID"]; $i + +; } for ($i = 0; $i < count ($r); $i + +) { if ($i > 0) { if ($r [$i] [' aid '] = = $r [$i -1][' aid ']) { Echo ' first '. $i. ' Piece of data '. $r [$i] [' aid ']. ' With previous data '. $r [$i -1][' aid ']. ' Repeat '. ' <br/> '; $sql = INSERT into Phpcms_content (SELECT). $r [$i] [' aid ']. "+ 520,". $r [$i] [' Cateid ']. ", News_catid, CATID, typeid, area IDs, title, style, thumb, keywords, keywords, posids, url, listorder, status, UserID, username, inputtime, updatetime, Sear Chid, Islink, prefix from phpcms_content WHERE ContentID = ' ". $r [$i -1][' aid ']." "; $sql = INSERT into Phpcms_c_news (SELECT. $r [$i] [' aid ']. "+ 520, template, titleintact, content, Groupids_view, READP Oint, author, CopyFrom, Paginationtype, Maxcharperpage, sub_title from phpcms_c_news WHERE ContentID = ' ". $r [$i -1][' aid '] ."')  "; echo $sql. ' <br/> '; $result = $connector-> query ($sql); INSERT into Test (SELECT ID +, name, class, score from test WHERE id = ' 1 '); } else if ($r [$i] [' aid ']!= $r [$i -1][' aid ']) { $sql = "UPDATE phpcms_content SET Origin_cateid = '". $r [$i] [' Cateid ']. "'  WHERE ContentID = ' ". $r [$i] [' aid ']." "; echo $sql. ' <br/> '; $result = $connector-> query ($sql); } } }

If you do not need to insert, it is simpler: INSERT INTO MyTable (SELECT * mytable where id=1) on DUPLICATE KEY UPDATE id=2;