Antonio Ramirez

If you were to log in, you'd be able to get more information on your fellow community member.

Static Page Comments

• March 19, 2007, on Introduction to Database Management Systems:

  I'm using MySQL, and I wanted to comment on a snag I ran into while I was following the tutorial in this page. Maybe other newbies can benefit from this. As far as I can tell: a) MySQL supports different "storage engines" for tables. This is presumably a good thing. However, not all engines support referencial constraints. b) For a MySQL table to support a "references" constraint, it must be of type InnoDB. In my installation (on SuSE Linux, right out of a standard RPM binary package), this is *not* the default. So you have to either change the server configuration to make this the default, or specify "ENGINE = InnoDB" after the closing parenthesis in the table definition. c) Even for InnoDB, the syntax described by Phil above does not work, though it is not rejected, merely ignored. According to the manual, this is effectively just a comment to the developer that this column is supposed to reference another column, even if the constraint is not enforced by mysql. d) So,...