MySQL/SQL Command Problem should be Simple

Question

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

you don't use ticks for wrapping string but single/double quotes. — George G, Apr 10 '20 at 02:25
Does this answer your question? [When to use single quotes, double quotes, and backticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) — P.Salmon, Apr 10 '20 at 07:03

score 1 · Accepted Answer · answered Apr 10 '20 at 02:25

1

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.

answered Apr 10 '20 at 02:25

Gordon Linoff

1,242,037
58
646
786

score 0 · Answer 2 · answered Apr 10 '20 at 03:13

0

just use single quotes NOT ticks. Below query should work

update players
set online = 0
where uuid = '5f1d55a9-0e01-4540-a978-6697fdf2db1f';

answered Apr 10 '20 at 03:13

zealous

7,336
4
16
36

MySQL/SQL Command Problem should be Simple

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

2 Answers2