Jump to content

MySQL Help


Recommended Posts

Hi,My Frnd Then What is the Use of Foriegn Key?Use it and Get your Data From another tableForeign key: Primary Key of one table Thaat is the Foreignn Key in another table as Column with same name Same Value to get dat from another TableSo Use it.If U find Solution of link Then plz tell me alsoBye

Link to post
Share on other sites

Actually I am a little new to all thisThe purpose for this is that i want to link member username,password ,email fields of a SMF forum with a IPB forumBoth of them are stored in the same DB but but different DB namesI wanted that a member on registering on either one of the forum should get access to the other one alsoI know its a little difficult but if u or anyone can help i would greatly appreciate itSo pls help meThanx in advance

Link to post
Share on other sites

I am not sure I exactly understand your question, but I guess my first question for you is why don't you just create one table/database for the two to access, at least as far as this information is concerned?And I don't know if this works on MySQL or if it will even help answer your question but but you can access/join tables from different databases, in MS SQL you can do it by listing out the full address for the table. For example:select * from database1.dbo.table1where [insert where statements here]

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...