My table structure is like this, using sqlite3
CREATE TABLE enghindi (eng TEXT,hindi TEXT)
i have an table named enghindi in that there is two column named hindi, eng, i want to merge eng column's record and also combine hindi word by comma separated
look at the below table is looking like
i want to do look like this below
i want to do this with sqlite3 query
This should work:
SELECT GROUP_CONCAT(eng), hindi FROM enghindi GROUP BY hindi;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With