[fenbers]

Once I converted my MyISAM tables to InnoDB, I was able to create foreign keys on my MySQL DB using MyEclipse tools. Apparently, MySQL only allows foreign key constraints on tables where ENGINE=InnoDB. I had to use an outside tool to set the ENGINE=InnoDB of the tables I wanted to be involved with foreign keys. It would have been nice if MyEclipse allowed me to change this within itself, but I had to use an outside tool to do this. Is there a way to stay totally in MyEclipse and change the tables from MyISAM (default) to InnoDB?

Mark

[Loyal Water]

Is there a way to stay totally in MyEclipse and change the tables from MyISAM (default) to InnoDB?

Thi is something thats not possible.

[Author]

Posts