Hello everybody


I need to know whether MySQL supports referential integrity under MyISAM tables. I want to create two tables with a one-to-many relation. The one side of the relation should not be deleted if there exists at least one record in the many side.

e.t.c.

CREATE TABLE SPARE_PART (
repair_id LONGINT UNSIGNED FOREIGN KEY REFERENCES REPAIR.repair_id,
other fields);

Syntax like that works under Oracle (not sure this is syntax-error free as I recalled it from memory, but the concept is the same). Can I write such SQL statements under MySQL using MyISAM tables?

thx, in advance

George Papadopoulos

You need to use innodb tables for this.

Try to setup INNODB table space to use referential integrity

http://www.lasso-developpeur.net/us/...tab=db&lang=us

Hi,
In case that i have already build up the myISAM-type db, and inserted data in. I have searched that we can not convert mySIAM-type table to innoDB-type directly.

I want to ask whether there is a solution for this?
Can export insert script, delete existing db, create a fresh one, run the insert sql solve it?

Thanks

Either I don't understand this right, or the info you have read is seriously wrong. To me it seems that what you want to do is set up InnoDB and then

ALTER TABLE tab ENGINE=InnoDB;

Your informaiton is out of date.

http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html