如果id是连续的可以这样写, for($i=$startId; $i<=$endId; $i++){ @mysql_query("UPDATE `tablename` SET A=id WHERE id=$i"); }id不连续可以这样: $idArr = @mysql_fetch_array(mysql_query(SELECT `id` FROM `tablename`"); foreach($idArr as $id){ @mysql_query("UPDATE `tablename` SET A=id WHERE id=$id"); }
for($i=$startId; $i<=$endId; $i++){
@mysql_query("UPDATE `tablename` SET A=id WHERE id=$i");
}id不连续可以这样:
$idArr = @mysql_fetch_array(mysql_query(SELECT `id` FROM `tablename`");
foreach($idArr as $id){
@mysql_query("UPDATE `tablename` SET A=id WHERE id=$id");
}