Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,656
    Member #
    1234
    Liked
    137 times
    Got a couple of questions:
    1. Does anyone know of a program (preferrably free) that lets you set up a db relation in GUI fashion, or at least to look at one in this way? For me, it's easier to organize then at a glance.

    2. Does anyone recommend a good database/mySQL book? Can't find my old textbook and I need a refresher course.

    3. Key question: In the following table, am I correct in assuming that cat_id and man_id should be keys, as they are primary keys in other tables, but name shold not be, as the name is not explicitly mentioned in any other tables?

    CREATE TABLE `model_name` (
    `id` int(8) unsigned zerofill NOT NULL auto_increment,
    `cat_id` int(3) unsigned zerofill NOT NULL default '0',
    `man_id` int(3) unsigned zerofill NOT NULL default '0',
    `name` varchar(255) NOT NULL default '',
    PRIMARY KEY (`id`),
    KEY `name` (`name`)
    ) TYPE=MyISAM;
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com

  2.  

  3. #2
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    1. http://www.phpmyadmin.net/ (somewhat GUI but better than nothing)
    2. PHP/MySQL Web Development (IIRC) by Sams Publishing
    3. id should be the primary key.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  4. #3
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,656
    Member #
    1234
    Liked
    137 times
    1. To me, phpmyadmin is just a GUI interface to the mySQL server. I'm looking for something like Access, where it draws representations of tables and how they relate to each other.

    3. Ack, copied it here wrong, id is the primary key. I was more asking about KEY `name` (`name`). In otherwords, name shouldn't be a relation key, but cat_id and man_id should be, as they are primary keys in other tables?
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 12:14 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com