how to update multiple rows with same value in mysql [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Closed 4 years ago.

Hi I have a table data as below

I want to update all department column data consisting "DA" to "DATA ANALYTICS" in a single query. Help me with this — Pradeep GN
– Pradeep GN, Commented Jan 7, 2021 at 12:25
That's a very simple update with a where - what have you got so far? — P.Salmon
– P.Salmon, Commented Jan 7, 2021 at 12:27
i have to write 7 update queries to update.for example - update emp set 'department'='DATA ANALYTICS' where pk_id = 1; so on. But is it possible to do with single query — Pradeep GN
– Pradeep GN, Commented Jan 7, 2021 at 12:30

Squirrel · Accepted Answer · 2021-01-07 12:46:57Z

1

Try this , Thanks

UPDATE emp SET department='DATA ANALYTICS' WHERE department='DA'
GO

Squirrel

24.8k5 gold badges41 silver badges37 bronze badges

answered Jan 7, 2021 at 12:35

Bhushan

362 bronze badges

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

2 Comments

Go is a sqlserver thing , mysql statement should be semi colon (;) terminated and this is a copy of a previous answer.

GO is not T-SQL no, but it is SQL Server related, @Squirrel . No one said it was T-SQL.

Iñigo Bereciartua · Accepted Answer · 2021-01-07 12:29:43Z

1

The statement would look like this

UPDATE your_table_name
SET Department= 'DATA ANALYTICS'
WHERE Department='DA';

answered Jan 7, 2021 at 12:29

722 silver badges12 bronze badges