SQLite Update Syntax for string concatenation?

Question

I have a table with this data

id , name    , description 1  , apple   , '' 2  , orange  , '' 

I am trying to pass the following statement to update the row so the description column is 'desc of apple' and 'desc of orange' but it is not working.

 Update TestTable Set description = 'desc of ' + name  

What is the proper syntax to concatenate strings?

Answer 1

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

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