How to Specify InnoDB table type

[eluser]Randy Casburn[/eluser]
[quote author="CW" date="1219267323"]That's what I suspected so I used:

$this->db->query("CREATE TABLE `hello` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=InnoDB AUTO_INCREMENT=1 ");

To get around this.[/quote]

Just to be a nerd, TYPE= is deprecated, ENGINE= is now preferred.

But it won't matter for some time.

Randy