mysqli int更新语法错误

Question

im试图在数据库上更新一个字段，但请继续获取我的SQLI代码具有语法错误的消息。我找不到这个错误，我在所有上限上都有并且在所有上限上都有ID，但它更改了它是由mysqli保留的（db.php只有我的数据库详细信息）

include ("db.php") ;    
    //  connect to the database to get current state
    $conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) { die("Connection failed: " . mysqli_connect_error());
    echo "fail";        }

也尝试过它为" on = 1"

    $sql = "UPDATE GreenLED SET On='1' WHERE Id=1";
    $result = mysqli_query($conn, $sql);
    if (mysqli_query($conn, $sql)) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . mysqli_error($conn);
}
mysqli_close($conn);

Answer 1

" on"one_answers" on"上的" on"是由sql保留的，所以我不得不更改为lon