I am using the RPM's, but it didn't give an error so I'm assuming it is properly configured. The MySQL version is:
[ken@ken ken]$ mysql --version mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686) Sorry -- I should have included that. I'm assuming there's something wrong with my syntax as I can't create Berkley tables either. Frankly I don't care what table type I use, I just want transactions -- and if I can get them, foreign keys w/ cascade deletes, etc... On Friday 28 December 2001 01:25 pm, Weaver, Walt wrote: > 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
