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 wrote:
>
> 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 VARCHAR columns. This doesn't affect
> how you use the columns in any way; in MySQL, VARCHAR is just a different
> way to store characters. MySQL performs this conversion because it saves
> space and makes table operations faster. See section 8 MySQL Table Types.
> *****
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
>
> - TIM FRASER
>
> > 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 table would look like:
> > v11,a11,b11,c11,a12,b12,c12,a1,b13,c13
> > v21,a21,b21,c21,a22,b22,c22
> >
> > Can you please help me with my problem?
> >
> > Thanx in advance.
> >
> > -Sagar
> >
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Auctions - buy the things you want at great prices
> > http://auctions.yahoo.com/
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
"Tyranny is any political system (whether absolute monarchy or fascism
or communism) that does not recognize individual rights (which
necessarily include property rights). The over-throw of a political
system by force is justified only when it is directed against tyranny;
it is an act of self-defense against those who rule by force. For
example, the American Revolution."
-- Ayn Rand
Rick Pasotto email: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
