Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is Mysql a relationnal database?
- Thread starter HoMyGod
- Start date
yes,
more info at
cheers devnull22
--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !
more info at
cheers devnull22
--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !
OK, for a slightly less terse answer:
MySQL is relational in that a query can use primary keys from one table to index records in another table, etc... It is NOT relational in the sense of providing full Foreign Key constraints. In other words, it can be used relationally, but it is possible to break the relationships if you don't program your application correctly. Databases that offer full Foreign Key support make it possible for the database design itself to prevent an application from "breaking" relationships. PostgreSQL ( supports this, as do most enterprise-level databases.
MySQL is relational in that a query can use primary keys from one table to index records in another table, etc... It is NOT relational in the sense of providing full Foreign Key constraints. In other words, it can be used relationally, but it is possible to break the relationships if you don't program your application correctly. Databases that offer full Foreign Key support make it possible for the database design itself to prevent an application from "breaking" relationships. PostgreSQL ( supports this, as do most enterprise-level databases.
- Status
