Can I update several elements of my table at the same time?

Question

Can I update several elements of my table at the same time?

Navigation

#1 by (0 votes)

0

I have a customer table from a bank box. There are different fields, such as Identifier, User_Code, User_Name, User_Current ... I have to modify a field of four different clients but they belong to the same table:

update miTabla
set Fec_Anulación = '26/03/2018 18:00'
where Cod_usuario in ('u251', 'u252', 'u253', 'u254')

but I do not know if the where statement gives me an error. Can you give me a cable? Thanks in advance

sql sql-server

asked by Miguel 26.03.2018 в 18:01

source

1 answer

Use of the WHERE NOT IN in Laravel unsupported keyword 'provider'

score 0 · Accepted Answer

0

To make sure you do not make an error, the modification should be like this

update miTabla
set Fec_Anulación = CONVERT(DATETIME, '2018-03-26 18:00',120)
where Cod_usuario in ('u251', 'u252', 'u253', 'u254')

answered by 26.03.2018 / 18:16

source