RE: a growing list as a field - Robert Goff - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRE: a growing list as a field

From	Sent On	Attachments
Noah Silverman	17 Jul 2000 07:33
Dana Powers	17 Jul 2000 09:25
Robert Goff	17 Jul 2000 09:46

Subject:	RE: a growing list as a field
From:	Robert Goff (rob...@goff.com)
Date:	07/17/2000 09:46:53 AM
List:	com.mysql.lists.mysql

The concept is to build a database file with two fields. The first field is a unique process id. The second field is a list of files.

You should have one row per filename. If you need a unique id for each filename, add another column.

To add a file, insert a new row with the filename and process id. To remove a file, delete its row. To find all the files, select filename from table where process_id=?.