SQLite Update Syntax for string concatenation?
SQLite's string concatenation operator is "||
", not "+
"
UPDATE TestTable SET description = 'desc of ' || name;
SQLite's string concatenation operator is "||
", not "+
"
UPDATE TestTable SET description = 'desc of ' || name;