I'm using this to try and name the values in NAME to ValueOLD
UPDATE PLAYERS SET NAME = NAME 'OLD';
However I am receiving
Execution finished with errors.
Result: UNIQUE constraint failed: PLAYERS.NAME
At line 1:
UPDATE PLAYERS SET NAME = NAME 'OLD';
I've seen some questions asked on inserts that look like they work, but haven't had any success with UPDATE or SET
CodePudding user response:
In SQLite
, ||
can be used for concatenation.
So Try:
UPDATE
PLAYERS
SET
NAME = NAME || 'OLD';