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 te
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 mailin
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 imag
3 matches
Mail list logo