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
