innodb storage engine in mysql

[shivani.shm]

hi

I have created a table structure and used engine type as Innodb but the defaukt is taken as myisam

and bcoz of tht i can't use referential integrity...

My mysql version is 4.0.15.

 

plz help out

thanks in advance...

[~n[EO]n~]

Did you define the Engine

CREATE TABLE test (i INT) ENGINE = INNODB;

 

If you haven't defined then default will be used, you can

 

ALTER TABLE test ENGINE = INNODB;