O'Reilly Forums: Help Me, Please! - O'Reilly Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Help Me, Please! I have a problem with command 'create table' for foreign keys.

#1 User is offline   Danlod 

  • New Member
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 09-November 12

Posted 09 November 2012 - 10:39 AM

Hello everyone!
Help me, please, with my problem.

Look at my screenshot, please.

http://vvcap.net/db/...5lOYtXDlLFE.htp

Why i can create table contact_interest, but unable create table contact_seeking?

Thank you!
0

#2 User is offline   heybales 

  • New Member
  • Pip
  • Group: Members
  • Posts: 4
  • Joined: 25-July 12

Posted 10 November 2012 - 05:13 PM

My guess is that the table seeking does not have a primary key called seeking_id.

Also, I don't think you want auto increment on either of those tables.
0

#3 User is offline   drewdin 

  • Super Veteran Member
  • PipPipPipPipPipPipPipPipPipPipPip
  • Group: Members
  • Posts: 589
  • Joined: 11-February 10
  • Gender:Male
  • Location:Boston

Posted 05 March 2013 - 08:48 AM

did you plan on contact_id1 for a column name?

also, is your table name contacts_seeking or just seeking as you have listed?

This post has been edited by drewdin: 05 March 2013 - 08:49 AM

0

#4 User is offline   jacksonbird03 

  • Active Member
  • PipPip
  • Group: Members
  • Posts: 39
  • Joined: 22-February 13
  • Gender:Male
  • Location:Kailua Kona
  • Interests:Massage

Posted 20 March 2013 - 02:13 AM

Hey, I think that the table seeking does not have primary key i.e. seeking_id..
[url= http://www.konaspa.com/Island_Specialty_Packages.html ] Full Body Massage Kona [/url] |
[url= http://www.konaspa.com/Chiropractic.html ] Kona Chiropractic [/url]
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users