I am migrating data from a database which has a table that describes items by
kinds. Instances of those kinds are stored in one column of this table,
listing each instance's id, with all ids separated by a slash /.
Of course, this is a very poor design. The target system has a proper table for
:28 AM
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] splitting a line to produce several lines?
I am migrating data from a database which has a table that describes items by
kinds. Instances of those kinds are stored in one column of this table,
listing each instance's id
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] splitting a line to produce several lines?
I am migrating data from a database which has a table that describes items by
kinds. Instances of those kinds are stored in one column of this table,
listing each instance's id, with all ids
On Mon, Sep 12, 2011 at 12:28 PM, Jean-Denis MUYS jdm...@kleegroup.com wrote:
My question is: is there a pure SQL way to split the instances string, and
generate the instance lines from the instance list string? contrived example:
This kind of questions appear from time to time (including my
Database
Subject: EXT :Re: [sqlite] splitting a line to produce several lines?
On 12 sept. 2011, at 13:26, Black, Michael (IS) wrote:
Since SQL is designed to return rows I believe the answer is no since you're
data is not stored in rows.
I suspected such a limitation. Thanks