I have a column in table with type character varying here is the query:
update logins
set access_token='l38r8cfjm31b38ye91yjn1956vr3n74tc5sc0btholj0iain77' and uuid='123456789'
where username = 'PWD_2006'
It give me the error:
ERROR: invalid input syntax for type boolean: "l38r8cfjm31b38ye91yjn1956vr3n74tc5sc0btholj0iain77"
LINE 1: update logins set access_token='l38r8cfjm31b38ye91yjn1956vr3... ^
SQL state: 22P02
Character: 32
and
by a,
(comma)