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
