How to update a record in my table using direct database query

Hi

I am struggling to update table using direct database query
I have a test table


Table name is

mvpw4_42

or

x4_42



These are the things I tried

UPDATE x4_42 SET maker = 10 WHERE id = 1;
Failed

UPDATE mvpw4_42 SET xdo = '{"test": "aby", "maker": 10, "created_at": 1749790361933}'::jsonb WHERE id = 1;
Doesnt show erros , but doesnt update values either


|Inserts dont work too

How can I fix this ?


SELECT * work fine
Update / Insert dont.
Xano sql AI isnt working either,.

7 replies