[RESOLVED] MySQL table creation problem

[CybJunior]

hi,
I have already done such things and worked properly but now i can't create a table. Here's an example:

CREATE TABLE animals(
id MEDIUMINT NOT NULL AUTO_INCREMENT ,
name CHAR( 30 ) NOT NULL ,
PRIMARY KEY ( id )
)

It causes: #1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working
How do i create a MyISAM Table?

[rincewind456]

Change your statement to

CREATE TABLE animals(
id MEDIUMINT NOT NULL AUTO_INCREMENT ,
name CHAR( 30 ) NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;

[CybJunior]

Thanks a lot...
Im sorry for such stupid post...

[rincewind456]

CybJunior wrote:

Thanks a lot...
Im sorry for such stupid post...

We all start somewhere, don't forget to mark the post RESOLVED