I
I
Ivan Shevtsov2018-05-19 13:31:22
MySQL
Ivan Shevtsov, 2018-05-19 13:31:22

How to change the content of one column for all rows in one MySQL table?

Hello. How to change the content of one column for all rows in one MySQL table?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sergey, 2018-05-19
@irain

UPDATE `table` SET `column` = 'param'

C
coderisimo, 2018-05-19
@coderisimo

this is how all users can be sent to Uryupinsk at once))
UPDATE user u SET u.address = 'Urupinsk'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question