What you want is 'foreign keys', a feature which MySQL does not support.
It's on the TODO list though...
If you really wanted, you could scan table B periodically and update the
Table A definition, but this is a very hack-ish way of doing it. You
probably want to do all this work in your API (ie, read Table B to verify
the integrity of Table A.)
-Kevin
--On Sunday, May 13, 2001 4:11 PM -0400 Carl Miller
<[EMAIL PROTECTED]> wrote:
> Hello group -- I'm a newbie using phpMyAdmin to manage a test database.
>
> Here's my Q: In Table A, lets say Column X is of type SET. Can the
> allowed values of Column X be defined by the values of Column Y in Table
> B, *AND* be automatically updated when the values of Column Y in Table B
> change?
>
> How do I define Column X in Table A (using phpMyAdmin) to do this?
>
> Thanks!
>
> Carl Miller
>
> ---------------------------------------------------------------------
> 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]
> om> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
====================================================================
Kevin C. Miller - Carnegie Mellon University -
[EMAIL PROTECTED] - School of Computer Science - 412.512.3144
--------------------------------------------------------------------
---------------------------------------------------------------------
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