On Mon, Jun 16, 2008 at 04:52:56PM -0700, Joanne Pham scratched on the wall:
> Thanks Igor,
> Do I need to upgrade to latest vresion of SQLite?
> I have to rebuild the SQLite library again. What version that I
> need to upgrade to for group_concat function
group_concat() became official in 3.5.
Monday, June 16, 2008 3:46:20 PM
Subject: Re: [sqlite] Display all the columns of the table in single line.
Joanne Pham <[EMAIL PROTECTED]> wrote:
> I got this error message. I had 3.5.2 SQLite.
> sqlite> select group_concat(appName) from CDB.appMapTable;
> SQL error: no suc
Joanne Pham <[EMAIL PROTECTED]> wrote:
> I got this error message. I had 3.5.2 SQLite.
> sqlite> select group_concat(appName) from CDB.appMapTable;
> SQL error: no such function: group_concat
Upgrade to more recent SQLite version. group_concat is fairly new.
Igor Tandetnik
___
ite-users@sqlite.org
Sent: Friday, June 13, 2008 7:45:08 PM
Subject: Re: [sqlite] Display all the columns of the table in single line.
"Joanne Pham" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I ran the following select :
> select appName from appMapTable
>
"Joanne Pham" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I ran the following select :
> select appName from appMapTable
> but I would like all the appName return as single row and seperate by
> comma. Can we do that using sqlite commands.
select group_concat(appName) from appMap
Hi All,
I ran the following select :
select appName from appMapTable
but I would like all the appName return as single row and seperate by comma.
Can we do that using sqlite commands.
Thanks so much.
JP
"
___
sqlite-users mailing list
sqlite-users@sqli
6 matches
Mail list logo
