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.

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)

Thanks..

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

You could read up on how to create a relationship (i.e. constraint) in SQL, rather than with a GUI :P :)