Results 1 to 3 of 3

Thread: Problem with Foreign key?

  1. 05-09-2005, 08:11 AM #1
    mallik345
    mallik345 is offline Registered User
    Join Date
    May 2005
    Location
    India
    Posts
    1

    Angry Problem with Foreign key?

    Hello Friends ,This is Mallik,new to Mysql and new to this forum.i have problem with foreign key .i create tables using reference,but when we enter data into table it is accepting without refering to the referencing table.What i have to do?pls help me.
    ur's
    Mallik.
    Reply With Quote Reply With Quote
  2. 05-14-2005, 10:57 PM #2
    oraclable
    oraclable is offline Registered User
    Join Date
    Apr 2005
    Location
    florida
    Posts
    89
    Because you created a (0,n)-relationship.
    You just need to make it (1,n) by making that reference column NOT NULL.


    Good luck!
    Reply With Quote Reply With Quote
  3. 05-18-2005, 04:06 PM #3
    greenman
    greenman is offline Registered User
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    More details would help, but it's probably because the default MyISAM tables don't support foreign key constraints. Use an InnoDB table instead.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules