UPDATE update without affecting all rows in table without ID [closed]

Question

UPDATE update without affecting all rows in table without ID [closed]

Navigation

#1 by (0 votes)

1

I have a table with information from some clients and I needed to give UPDATE however as the table has no ID and most of the data is repeated including cpf is there any way to give the where on the selected line only?

sql ms-access

asked by anonymous 20.12.2018 / 16:10

1 answer

Java web, jstl: How to execute a method in the servlet when exiting an input text ex: "check if the availability of name to register" Laravel - How to page and give Order By

score 0 · Answer 1

0

Placing multiple conditions in WHERE and a limit in 1 EX:

UPDATE usuarios set name = 'SEU NOME' WHERE CPF = '123' and IDADE = '13' and RG = '433' and SOBRENOME = 'SOBRENOME' LIMIT 1

26.12.2018 / 18:55