MySQL Forums
Forum List  »  Chinese

converting the storage engine InnoDB to MyISAM?
Posted by: sindy lee
Date: March 20, 2008 07:59AM

How can i convert the storage engine InnoDB to MyISAM?

I'd tried the followings, but they didn't work.

1. create a new table in my datebase with:

CREATE TABLE customers
(custid INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name CHAR(40) UNIQUE) ENGINE=MyISAM;

2. alter a already existed table with:

ALTER TABLE table_name TYPE=MyISAM;

What should i do?
Help!Help!

Options: ReplyQuote


Subject
Views
Written By
Posted
converting the storage engine InnoDB to MyISAM?
9067
March 20, 2008 07:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.