Re: [sqlite] Is it possible to concatenate an arbitrary number of columns into one?
As Simon points out there is no SQL solution to your issue. Some sort of external utility processing with things like awk, sed or even cut may assist or for a quick and dirty method you could set the sqlite3 command line utility .separator value to a blank string which may (or may not) provide a temporary method. Not in raw SQL though. On Wed, 21 Nov 2018 at 11:32, Simon Slavin wrote: > On 20 Nov 2018, at 11:54pm, Shane Dev wrote: > > > Is there an SQL statement to concatenate all columns into a single > column without explicitly naming them? > > No. And I can't think of any short-cut way to do what you want. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, Michael.j.Falconer. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is it possible to concatenate an arbitrary number of columns into one?
On 20 Nov 2018, at 11:54pm, Shane Dev wrote: > Is there an SQL statement to concatenate all columns into a single column > without explicitly naming them? No. And I can't think of any short-cut way to do what you want. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Is it possible to concatenate an arbitrary number of columns into one?
Hello, An asterisk in the result-column represents all columns from the FROM clause without explicitly naming them, https://www.sqlite.org/syntax/result-column.html Is there an SQL statement to concatenate all columns into a single column without explicitly naming them? If it existed, I could imagine something like - select concat(*) from table/view/query/etc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users