Ken, When you configured/compiled MySQL, did you use the --with-innodb option? What version of MySQL are you running?
FWIW, I wasn't real impressed with the Berkeley tables, but the InnoDB tables work very well. --Walt Weaver Bozeman, Montana -----Original Message----- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 1:09 PM To: [EMAIL PROTECTED] Subject: Forcing Table Types This is getting really annoying. No matter what type of table I create, it ends up being MyISAM. I _must_ have at least transactions and foreign key support would be nice. Also, does anyone know how I can have transactions on create table statements? Here the interaction with MySQL that is driving me crazy. It's kind of messy, but you'll notice my foo table ends up being MyISAM. The same thing happens for Berkley tables. mysql> create table foo ( -> foo_id int auto_increment not null, -> whatever text, -> primary key(foo_id) -> ) type=InnoDB; Query OK, 0 rows affected (0.00 sec) mysql> show create table foo; +-------+------------------------------------------------------------------- ----------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------- ----------------------------------------------------------+ | foo | CREATE TABLE `foo` ( `foo_id` int(11) NOT NULL auto_increment, `whatever` text, PRIMARY KEY (`foo_id`) ) TYPE=MyISAM | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php