S
S
Shellr57s2019-12-13 02:25:46
MySQL
Shellr57s, 2019-12-13 02:25:46

How to properly escape the column name?

Hello everyone,
The question is how to escape the name of the column directly in the query?
Here is a simple example, the column name corresponds to the update statement:

update stats set update='100', pdef='100', mdef='100' where id='500';

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-12-13
@Shellr57s

update `stats` set `update`='100', `pdef`='100', `mdef`='100' where `id`='500';

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question