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
– George G, Commented Apr 10, 2020 at 2:25
Does this answer your question? When to use single quotes, double quotes, and backticks in MySQL — P.Salmon
– P.Salmon, Commented Apr 10, 2020 at 7:03

Gordon Linoff · Accepted Answer · 2020-04-10 02:25:11Z

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, 2020 at 2:25

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zealous · Accepted Answer · 2020-04-10 03:13:56Z

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, 2020 at 3:13

zealous

7,5434 gold badges20 silver badges39 bronze badges

Collectives™ on Stack Overflow

MySQL/SQL Command Problem should be Simple

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related