Results 1 to 2 of 2

Thread: Constrain insert on duplicate in other table

  1. #1
    209
    posts
    Registered User

    Constrain insert on duplicate in other table

    I'm trying to figure out if there's a way to do a unique check across multiple tables. I'm checking the users ip for a survey, and we're creating a new one in which we don't want people who took the first one to take. I'm wondering if it's possible to do this in 1 statement? I know I can easily do this in 2 statements with a bit of server side logic, but I'm more curious about it in an educational way.

    If MySQL were to support constraints would I be able to do a CHECK (count(table.ip) = 0), or would that not be possible since I'm referencing a different table? What would be the proper way to do that?

    Thanks to anyone who knows!

  2. #2
    1,627
    posts
    hugeExplosions = true;
    The question is - why would you want to do this? Your IP information should only be contained in one table - you should not have multiple tables which contain a users IP address or you are creating data redundancy

    Can you describe your setup in more detail?
    MS Paint FTW!


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
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012