Results 1 to 4 of 4

Thread: MySQL Control Center

  1. #1
    Senior Member
    Join Date
    Aug 2003
    Posts
    6,562
    Thanks
    0
    Thanked
    245 times in 207 posts

    MySQL Control Center

    Hello,

    Does anyone here use MySQL Control Center? I can't seem to find a decent tutorial for it. For most part, it is pretty intuitive (creating DBs, Tables, etc.), but I can't seem to find an option to join 2 tables (e.g. Specify a one-to-many relationship). Can anyone point me to the right direction?

    Thanks.

  2. #2
    bored out of my tiny mind malfunction's Avatar
    Join Date
    Jul 2003
    Location
    Lurking
    Posts
    3,923
    Thanks
    191
    Thanked
    187 times in 163 posts
    • malfunction's system
      • Motherboard:
      • Gigabyte G1.Sniper (with daft heatsinks and annoying Killer NIC)
      • CPU:
      • Xeon X5670 (6 core LGA 1366) @ 4.4GHz
      • Memory:
      • 48GB DDR3 1600 (6 * 8GB)
      • Storage:
      • 1TB 840 Evo + 1TB 850 Evo
      • Graphics card(s):
      • 290X
      • PSU:
      • Antec True Power New 750W
      • Case:
      • Cooltek W2
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Dell U2715H
    Does MySQL support constraints?

    ...

    Just checked and the InnoDB format supports them - "Foreign Key Constraints" is what you want:

    http://www.mysql.com/doc/en/InnoDB_f...nstraints.html

    Though you'll have to set them up via SQL by the looks of it (no crappy 'relationships' GUI like in MS Access)

  3. #3
    Senior Member
    Join Date
    Aug 2003
    Posts
    6,562
    Thanks
    0
    Thanked
    245 times in 207 posts
    Thanks..

    I liked those "crappy relationships" in Access
    They are somewhat intuitive..

  4. #4
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    You could read up on how to create a relationship (i.e. constraint) in SQL, rather than with a GUI
    Simon


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PHP and MySQL
    By Kezzer in forum Software
    Replies: 4
    Last Post: 28-10-2003, 02:59 PM
  2. enermax psu with fan control
    By Merlin in forum PC Hardware and Components
    Replies: 10
    Last Post: 27-10-2003, 03:50 PM
  3. Remote control fart machines
    By Jimmy Little in forum General Discussion
    Replies: 13
    Last Post: 09-10-2003, 11:13 PM
  4. bandwidth control
    By kemosabe in forum Networking and Broadband
    Replies: 2
    Last Post: 20-09-2003, 02:01 PM

Posting Permissions

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