MySQL update 欄內自加1[例counter]

基於MySQL數據庫計數器的基礎

$sql = "UPDATE test_table SET test_field = test_field + 1 WHERE id = $id";
$result = $db->query($sql);