SQLite Forum


1 forum post by user nehemiahnarzary

13:50 Post: Update table from SQLite3 queries results. (artifact: de36243266 user: nehemiahnarzary)

I've a table with 2 columns (word and meaning). word column contains same entry in many rows so I want to make them together.

This following query gives me good result but I can't update my table.

SELECT word, group_concat(meaning, '/') as meaning FROM Table1 GROUP BY word;

This works for me. But the thing is I can't update it to my table.