Dovalle Yankelovich wrote: >Hi, >Im new with MySql and with DB in general. >I want to add data to my table but some of the information is data of other >table, e.g. let say I have >table of Machine and one field is the OS which I have table for it (I don't >want anyone to give it in its format so I will make a list and I want >everyone to choose from the list). >Hoe can I do it directly from the MySql prompt and how from Perl script > > > There are a few options. Have a look at the these variable types: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ENUM These allow you to manually set the available options for a specific field. -- Michael Pemberton mpember at phreaker.net ICQ: 12107010