[thelist] MySql Help

Michael Pemberton mpember at phreaker.net
Mon Sep 9 08:42:00 CDT 2002


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







More information about the thelist mailing list