如何将表存储引擎从MyISAM更改为InnoDB [英] How to change table storage engine from MyISAM to InnoDB

问题描述

我执行了命令show table status，发现所有表的引擎类型均为MyISAM.我想将引擎类型更改为InnoDB.

I executed the command show table status and found that all my tables had the engine type as MyISAM. I want to change the engine type to InnoDB.

我搜索并找到了相应的查询，并将其写为:-

I searched and found the respective query and wrote it as :-

alter table PROJECT_TITLES_ORGANIZATION ENGINE=INNODB; 

但是这不起作用，我收到了此错误消息:

but this did not work, I got this error message:

You have an error in your SQL syntax near 'ENGINE=INNODB' at line 1.

我正在使用的MySql版本是3.23.54a-11.

I 'm using MySql version is 3.23.54a-11.

请告诉我为什么会发生这种情况以及如何使其起作用?

Please tell me why is this happening and how to make it work?

推荐答案

我认为您无法在您的版本中做到这一点.来自用于创建表的旧MySQL文档. .

I don't think you can do that in your version. From old MySQL docs for CREATE TABLE . . .

ENGINE和TYPE选项指定表的存储引擎. ENGINE已添加到MySQL 4.0.18(对于4.0)和4.1.2(对于4.1)中.

The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1).

这篇关于如何将表存储引擎从MyISAM更改为InnoDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！