Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- When to use a new Field and when to use a new Table


drongo - 12:30 pm on Jan 11, 2011 (gmt 0)


A comma-separated list is a form of data table.

So why not simply use a real table, with all its attendant benefits, such as indexing, searching, sorting, inserting, deleting etc?

There's no inherent support for any of the above functions with comma-separated lists in a field in most database systems.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4250823.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com