Results 1 to 3 of 3

Thread: On Insert?

  1. #1
    Join Date
    Jun 2007
    Location
    London
    Posts
    117

    Unanswered: On Insert?

    Hello all,

    I have a table called membersand another table called settings. Every time I add a new user to members is it possible to have the ID of that user added, be added to the settings table automatically?

    I am hoping there is something equivalent to the "ON DELETE" and "ON UPDATE", is there a "ON INSERT"! (it seems fanicful)

    Thanks all

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, there isn't

    this sounds like a one-to-one relationship -- any reason why you couldn't combine the tables? at least then you wouldn't be asking this question

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    117
    :P lol - Actually there is no reason not to combine them. I really have problems with db design. I like breaking things up even if they have one-to-one relationship!

    Thanks for getting me to see the light r937

Posting Permissions

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