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: |
Todd Huss |
| Subject: |
Re: Relationships |
| Date: |
08-24-1999 10:26PM |
MySQL doesn't actually support foreign keys. The syntax permits you to create a foreign key for syntax compatability but there is no means to insure referential integrity.
It's discussed in the MySQL manual also but the expectation is that you code it yourself. The argument for it is increased performance in the database engine and against it is obviously it leaves more work to the programmers.
-Todd
www.little6.com
|
Other posts in this thread:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
