Re: newbie question on variable length records.

2001-05-01 Thread Rick Pasotto
I think he may be trying to put a variable number of *fields* in each record. This of course cannot be done directly. If that is what he wants he will need to have his own program merge/parse the data into a fixed number of MySQL fields (columns). On Tue, May 01, 2001 at 09:53:21AM -0400, Tim wro

Re: newbie question on variable length records.

2001-05-01 Thread Tim
This is straight from 7.7.1 of the MySQL manual: * If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to

newbie question on variable length records.

2001-04-30 Thread sagar tamhane
Hi, I am a newbie to Mysql. I would like to know how to create a table with variable length records? i have an object with following variables: varchar v, int a, int b, int c. and i want to store variable number of such objects into the rows. varchar v is the primary key. the entries in the