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
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
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