mysql修改表存储引擎_如何在MySQL中找出并更改表的存储引擎

mysql修改表存储引擎

How to find out and change the storage engine of tables in MySQL databases?

如何找出并更改MySQL数据库中表的存储引擎？

Find out the storage engine of a table in a database:

找出数据库中表的存储引擎：

SELECT ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'database'
AND TABLE_NAME = 'table'

Change the storage engine of a table:

更改表的存储引擎：

ALTER TABLE table ENGINE = type

type can be innodb or myisam or others supported.

类型可以是innodb或myisam或其他受支持的类型。

Set the default storage engine for the MySQL server:

设置MySQL 服务器的默认存储引擎：

set

组

default-storage-engine=type

in /etc/my.cnf.

在/etc/my.cnf 。

More about MySQL configuration: http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine

有关MySQL配置的更多信息： http : //dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine

Answered by anonymous.

匿名回答。

翻译自: https://www.systutorials.com/how-to-find-out-and-change-the-storage-engine-of-tables-in-mysql/

mysql修改表存储引擎