SQLite Forum

Update table from SQLite3 queries results.
Login
It will be much easier to `INSERT` it in a new table than `UPDATE` one row in Table1 and `DELETE` the other rows. Something like:

```sql
CREATE TABLE Table2 (
  word TEXT PRIMARY KEY NOT NULL
, meaning TEXT
) WITHOUT ROWID;

INSERT INTO Table2 (word,meaning) 
 SELECT word, group_concat(meaning, ' / ') as meaning
 FROM Table1 GROUP BY word;
```

Now verify the contents of Table2. If all is well:

```sql
DROP TABLE Table1;
ALTER TABLE Table2 RENAME TO Table1;
```