dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: link mySQL columns?

  1. #1
    Join Date
    Jul 2006
    Posts
    128

    link mySQL columns?

    i'm not new to mySQL, but i'm not familiar with advanced features, so my q is:

    is it possible to link a column in a table on one DB to a column in a different table on ANOTHER DB, such that wen one value is updated, so is the other?

    if so, how?

    thnx

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    i think what you want is a trigger, and they are supported as of MySQL 5.

    or maybe an update cascade. hmm.
    Last edited by chazzy; 03-08-2008 at 07:34 AM.

  3. #3
    Join Date
    Jul 2004
    Posts
    300
    sounds like bad design imho. you should probably not be doing this in true relational database coding.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles