Make MySQL relational

Discussion in 'Software' started by msteinblock, May 16, 2005.

  1. msteinblock

    msteinblock Private E-2

    How can I make tables relational in MySQL? It is really easy in MSSQL, just drag and drop. I cant find anything on how to make them relational in MySQL however. Do I have to do it manually with sql or is there a gui?

    Thanks!

    Matthew
     
    msteinblock, May 16, 2005
    #1
  2. goldfish

    goldfish Lt. Sushi.DC

    You simply set up a relationship using linked tables... look it up with SQL and whatever language you're using.
     
    goldfish, May 16, 2005
    #2
  3. msteinblock

    msteinblock Private E-2

    I am trying to accomplish referential integrity with MySQL. It was rather easy with MSSQL. Is it possible with MySQL? Is it done with Foreign Keys? And if so, is it possible to create/edit foreign keys in PHPMyAdmin?

    Thanks for the help!

    Matthew
     
    msteinblock, May 31, 2005
    #3

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds