★ wanayoo — archive 1999 http://www.devshed.com/Server_Side/MySQL/Join/comments.html/c1463/Nouvelle recherche | Portail wanayoo

Developer Shed
Thursday, 08.17.2000  
One of the great characteristics of SQL (Structured Query Language) is the
fact that one
can develop, access and modify data across various tables. There are several
benefits to
this, including greater ease of manipulation, increased speed of access, and
reduced
data redundancy. In MySQL (as well as many other SQL languages), this is
accomplished via the join command.

HOME > SERVER SIDE > MYSQL > ARTICLE > COMMENTS    PHP SOURCE

Power Search
Free Newsletter:


Client Side
DHTML
Flash
Graphics
JavaScript
XML

Server Side
Administration
JServ
MySQL
Perl
PHP
Python
Roxen
Zend
Zope

Tools
HTML Editors
Graphic Editors
FTP Programs

Dev Talk
Forums
Mailing List
Book Samples
Brain Dump
Developer News
Feedback

ClipScripts
Add script
Edit script

Other Stuff
DevShed RDF
Propaganda!


Advertise
on DevShed
.
MySQL Table Joins
One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop, access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, and reduced data redundancy. In MySQL (as well as many other SQL languages), this is accomplished via the join command.

Name: Gary Pupurs
Subject: Looking for tips on web DB design
Date: 09-26-1999 04:06PM

I'm hoping someone out there can point me to some links or actual paper books on laying out the design of tables and their relations when building databases for website use. Most of the books in stores on DB design are either all theory (college textbooks) or discuss distributed data warehousing type issues which are way beyond all but the most complex websites.
On the other end are the 'for Dummies' books, which I already basically know.

What I'm looking for is something in between, not necessarily e-commerce, but possibly. Something with a few challenging examples. I guess I just need some guidance on how to grok through thinking about relationships and the best ways to separate data into tables...

Any recommendations?




Other posts in this thread:
 Top
 • Looking for tips on web DB design  Gary Pupurs  09-26-1999 04:06PM 
       • Re: Looking for tips on web DB design  Alec Wearing  10-10-1999 03:46PM 
             • Re: Looking for tips on web DB design  Jill  10-19-1999 02:54PM 
                   • Re: Looking for tips on web DB design  Alec Wearing  10-24-1999 03:31AM 
                         • Re: Looking for tips on web DB design  paisit  07-08-2000 01:48PM 


Reply to this post:
Name:

Preview Comment.
Notify me of replies to this message.
Email:
Subject:
Tip: Put any source code between [code][/code] tags to increase readability


Visit the MySQL Forum!

New On DevShed:
• MySQL Developer Contests PostgreSQL Benchmarks
• PHP 101 (part 3) - Chocolate Fudge And Time Machines
• MaxSQL Announced
•  PHP 101 (Part 2) - Shakespeare's Rose
• PHP 101 (Part 1) - Secret Agent Man
• The Search For The Perfect Web Host
• Perl 101 (Part 5) - Sub-Zero Code
•  Submit Your News..

Hot Forum Topics:
• Credit Cards
• Backing-up in Netscape
• Want help from advanced PHP users
• making mysql timestamp look friendly
• display performance
• display performance


Adsmart Network ad
Copyright © 1997-2000 ngenuity. All rights reserved. Privacy Policy.