好资源导航 » 文章资讯 » MySQL-将表引擎从innoDB更改为MyISAM？

MySQL-将表引擎从innoDB更改为MyISAM？

2024-05-15 21:44:04 367

让我们首先创建一个表-

mysql> create table DemoTable1982
   (
   StudentId int
   ,
   StudentName varchar(20),
   StudentAge int
   );

让我们检查表格引擎类型-

mysql> show create table DemoTable1982;

这将产生以下输出-

+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table         | Create Table                                                                                                                                                                                                                         |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DemoTable1982 | CREATE TABLE `demotable1982` (`StudentId` int(11) DEFAULT NULL, `StudentName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `StudentAge` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

这是将表引擎从innoDB更改为MyISAM的查询-

mysql> alter table DemoTable1982 ENGINE='MyISAM';
Records: 0  Duplicates: 0  Warnings: 0

现在让我们检查表引擎类型-

mysql> show create table DemoTable1982;

这将产生以下输出-

+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table         | Create Table                                                                                                                                                                                                                           |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DemoTable1982 | CREATE TABLE `demotable1982` ( `StudentId` int(11) DEFAULT NULL, `StudentName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `StudentAge` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

MySQL-将表引擎从innoDB更改为MyISAM？

热门推荐

随机推荐