SQLite Update Syntax for string concatenation? SQLite Update Syntax for string concatenation? sqlite sqlite

SQLite Update Syntax for string concatenation?


SQLite's string concatenation operator is "||", not "+"

UPDATE TestTable SET description = 'desc of ' || name;