A Conversation for The H2G2 Programmers' Corner
MySQL database
Terran Started conversation Mar 31, 2003
Hi everyone, I've got a problem when creating database tables in MySQL. I'm using version 3.23.49, and am trying to create tables with TYPE=INNODB (because I want to use foreign keys), but when I check the table I find out that it has reset to TYPE=MYISAM. Any ideas, because I'm stumped.
Thanks,
Verc 
MySQL database
MaW Posted Mar 31, 2003
I wasn't aware that MySQL could handle foreign keys at all before version 4.0, no matter what table type you were using...
MySQL database
Terran Posted Mar 31, 2003
According to my sources, you can if you do the foreign keys as references, and set the TYPE to InnoDB. Which is what I've been trying to do, but for some reason, as I said, when I look at the table again MySQL had set it back to MyISAM. Apparently your supposed to be able to do this (according to <./>www.mysql.com</.>
with any version after 3.23.3# something (I can't remember the version number exactly, but I know I'm supposed to be able to do it).
Key: Complain about this post
MySQL database
More Conversations for The H2G2 Programmers' Corner
Write an Entry
"The Hitchhiker's Guide to the Galaxy is a wholly remarkable book. It has been compiled and recompiled many times and under many different editorships. It contains contributions from countless numbers of travellers and researchers."