gistfile1.txt

mysql> use test;
Database changed
mysql> create table test_innodb engine=innodb;
ERROR 1113 (42000): A table must have at least 1 column
mysql> create table test_innodb (id int not null primary key) engine=innodb;
Query OK, 0 rows affected, 2 warnings (0.09 sec)

mysql> show create table test_innodb;
+-------------+-------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                      |
+-------------+-------------------------------------------------------------------------------------------------------------------+
| test_innodb | CREATE TABLE `test_innodb` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------------+-------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select version();
+------------+
| version()  |
+------------+
| 5.1.55-log |
+------------+
1 row in set (0.00 sec)