Re: Is it possible to convert column data into rows

I have a column which contains a list of IDs separated by commas. How can I take the content of this column, and insert it into a temporary table so that each ID is on a separate row? Can this be done using SQL? Can be done in a stored procedure, or (more easily) in an application language.

Is it possible to convert column data into rows

I have a column which contains a list of IDs separated by commas. How can I take the content of this column, and insert it into a temporary table so that each ID is on a separate row? Can this be done using SQL? Thanks! Khai -- MySQL General Mailing List For list archives: http://lists.mysql.

Linking for maximum portability

Hello - I'm trying to build an executable that would be distributed in binary form, but needs to link to a MySQL DB - problem I'm finding is that the shared libs range in name libmysqlclient.so.15 , libmysqlclient.so.14, etc... And throw a run-time error when it isn't found... Is there a

innodb vs myisam

Hi all , Am not much knowledgeable person in mysql , but i know the query and all, But dont know the history and all about mysql , But i like to know , Can u please tell me , Here is difference what i know , innodb = suport concurrency , row level locking , rollback, commit myisam = support