* Alaios
> with myIsam? Does not check about integrity?
That is correct, the myisam table handler does not support foreign key
constraints. It does of course support foreign keys, but not foreign key
constraints, consequently the foreign key itegrity is not checked for myisam
tables.
> Mysql 3.2?
(I suppose you meant 3.23)
> What u will use for your application Innodb or MyISAM?
Both? It would depend on your needs. Foreign key constraints is neat, and in
some projects it might be a requirement, but the myisam table handler is
"lighter" because it does not do these checks, and it is also not
transactional, thus it is faster than InnoDB in many cases. myisam also
requires less disk space.
Read more about the different table handlers in the manual, and note that
you can combine different table types in the same database and in the same
statement:
<URL: http://www.mysql.com/doc/en/Table_types.html >
--
Roger

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.