Home > Enterprise >  SQLITE: Appending string to primary key
SQLITE: Appending string to primary key

Time:05-26

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';
  • Related