On Sat, Oct 25, 2003 at 12:47:16PM -0600, Miguel Maloney wrote:Does Mysql support repeatability of fields and subfields? and would it be well suited for a bibliographic database?
What is a 'subfield'? And what do you mean by 'repeatability'?
I think he's talking OLCL type stuff, which is a legacy monstrosity from before relational or object databases.
MySQL is a relational database, and if you want to jam a flatfile structure into it, you are going to need to define your own parsing routines for taking apart your fields and subfields.
Alternatively -- and perhaps someone has done this already -- you could devise a relational schema that expresses the data as expressed in your proprietary format such that your queries could *generate* legacy formats, but would not be based on them.
--bluejack
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]