Change the values of ENUM fields in the entire table with one query?

X

X

Xrist1An2015-04-29 11:51:03

MySQL

Xrist1An, 2015-04-29 11:51:03

Change the values of ENUM fields in the entire table with one query?

The table table has an enum field field with 2 values on and off . Now everywhere is off. Is it possible to transfer everything to on in one request ?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Andrey Mokhov, 2015-04-29
@Xrist1An

can:
UPDATE table SET field = 'on'

M

Mikhail Tikhonin, 2015-04-29
@phpclimber

update `table` set field1 = 'on', field2 = 'on' where ...
What is that?

Similar questions

S

strelkovandreyv2019-09-10 07:09:07

What is the PHP file manager with the ability to connect via SMB to Windows share? 2Reply

N

nerwind932021-04-07 15:31:56

How to substitute copied text in js? 3Reply

T

Timofey Belousov2015-05-12 23:15:48

Where and how to convert a png file to cur? To set the cursor on the site? 5Reply

G

gargamel12021-04-18 00:54:18

Working with multiple telebot keyboards? 1Reply

A

Alex2015-06-29 15:03:19

How to Livereload server side and client side at the same time using Gulp? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question