phpmyadmin：一次更新所有条目中的一行

Question

How can I update a row in all database entries? So I don't have to write for example 30 times a code to update each entry.

$query = $db->query("SELECT * FROM packages WHERE id = id");
$row = $query->fetch_object();

$number_now = $row->number-50;

$update_sale = $db->query("UPDATE packages SET number_now = '$number_now' WHERE id = id");

Answer 1

Perhaps try this

$update_sale = $db->query("UPDATE packages SET number_now = number_now-50");