SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2003
    Location
    Europe :-)
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How could I get images of MYSQL tables relationships?

    I'm referring to is a diagram of table relationships?
    Last edited by japaja; Feb 3, 2005 at 17:05.

  2. #2
    Non-Member
    Join Date
    Jan 2004
    Location
    Planet Earth
    Posts
    1,764
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use PSP7 at the moment, and if you COPY the text from DOS, and PASTE the text as a new image, PSP will create you a new image using the text

    Never used Photoshop though - Yuk

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    i think what japaja is referring to is a diagram of table relationships such as the attached, but which can be produced by software actually going into the mysql database and reading the table relationships

    japaja, a number of data modelling tools are reviewed here: http://www.databaseanswers.com/modelling_tools.htm

    i have heard good things about DBDesigner4 by FabForce.net but have not used it myself
    Attached Images Attached Images
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    Non-Member
    Join Date
    Jan 2004
    Location
    Planet Earth
    Posts
    1,764
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry

    Looked at DB Designer myself once - still have the exe on my HD and it looks stable, but I only had the time to take it for a test drive, if you understand ?

    Solve your problem though at the end of the day

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    golly gee, i wonder why japata went and deleted his question? what's up with that?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Addict ibeblunt's Avatar
    Join Date
    Jan 2001
    Location
    Jersey City, NJ
    Posts
    312
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The latest version of phpMyAdmin can also do table relationship images. It's pretty easy to set up. I just remember reading a document on Dev Shed about how to do it.

    Now I'm able to print out what my database looks like and how all the other tables relate to each other.

    Doing More With phpMyAdmin (Part 1)

    Doing More With phpMyAdmin (Part 2)
    Last edited by ibeblunt; Mar 4, 2004 at 20:31.
    <///////~

    www.sohh.com

  7. #7
    SitePoint Enthusiast
    Join Date
    Apr 2003
    Location
    Europe :-)
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    phpmyadmin? how?

  8. #8
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    happy new year, japeta!!

    nice job resurrecting a dead thread
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  9. #9
    SitePoint Enthusiast
    Join Date
    Apr 2003
    Location
    Europe :-)
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sorry I was in jail :-( for distibuting warez soft..

    so what about the answer on my question?

  10. #10
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    the answer was given almost a year ago

    try one of these data modelling tools --
    http://www.databaseanswers.com/modelling_tools.htm
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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