Skip to content
Advertisement

MySQL/SQL Command Problem should be Simple

I don’t know what I do false, Here the Code:

`UPDATE `Players` SET `online` = 0 WHERE `uuid` = `5f1d55a9-0e01-4540-a978-6697fdf2db1f`;`

Here the error:

SQL-Command: UPDATE Players SET online = 0 WHERE uuid = 5f1d55a9-0e01-4540-a978-6697fdf2db1f MySQL alerts: Dokumentation

1054 – Unknown table field ‘5f1d55a9-0e01-4540-a978-6697fdf2db1f’ in where clause

enter image description here

enter image description here

Advertisement

Answer

Using single quotes for strings and don’t bother escaping other identifiers:

UPDATE Players
    SET online = 0
    WHERE uuid = '5f1d55a9-0e01-4540-a978-6697fdf2db1f';

Easier to read as well as write.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement