Bagaimana membuat salinan data dalam MySQL dengan PHP

Tajuk dia dalam Inggeris 'How to duplicate a record in MySQL using PHP'.

// load the original record into an array
$result = mysql_query("SELECT * FROM {$table} WHERE {$id_field}={$id}");
$original_record = mysql_fetch_assoc($result);

// insert the new record and get the new auto_increment id
mysql_query("INSERT INTO {$table} (`{$id_field}`) VALUES (NULL)");
$newid = mysql_insert_id();

// generate the query to update the new record with the previous values
$query = "UPDATE {$table} SET ";
foreach ($original_record as $key => $value) {
if ($key != $id_field) {
$query .= '`'.$key.'` = "'.str_replace('"','\"',$value).'", ';
}
}
$query = substr($query,0,strlen($query)-2); // lop off the extra trailing comma
$query .= " WHERE {$id_field}={$newid}";
mysql_query($query);

Sumber: http://www.epigroove.com/blog/how-to-duplicate-a-record-in-mysql-using-php