如何使用MyISAM引擎表创建MySQL表？
要使用MyISAM引擎创建MySQL表，可以使用ENGINE命令。让我们首先使用CREATE命令创建一个表。
mysql> create table StudentRecordWithMyISAM -> ( -> Id int, -> StudentName varchar(100), -> StudentAge int -> )ENGINE=MyISAM;
上面，我们将引擎设置为“MyISAM”。
要检查表中有多少列，请使用DESC命令。
mysql> DESC StudentRecordWithMyISAM;
以下是输出。
+-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | Id | int(11) | YES | | NULL | | | StudentName | varchar(100) | YES | | NULL | | | StudentAge | int(11) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)
检查表是否与MyISAM一起提供。
mysql> SHOW TABLE STATUS FROM business LIKE 'StudentRecordWithMyISAM';
以下是清楚地表明引擎为MyISAM的输出。
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+ | studentrecordwithmyisam | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 1 | 2018-10-22 15:47:01 | 2018-10-22 15:47:02 | NULL | utf8mb4_unicode_ci | NULL | | | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+ 1 row in set (0.14 sec)
检查MyISAM表是否存在。
mysql> SELECT TABLE_NAME, -> ENGINE -> FROM information_schema.TABLES -> WHERE TABLE_SCHEMA = 'business' and ENGINE = 'MyISAM';
以下是输出。
+-------------------------+--------+ | TABLE_NAME | ENGINE | +-------------------------+--------+ | studentrecordwithmyisam | MyISAM | +-------------------------+--------+ 1 row in set (0.00 sec)
热门推荐
4 带清的简短祝福语
10 祝女性生日祝福语简短
11 订婚新发言简短祝福语
12 情人表白祝福语简短大气
13 祝寿时祝福语简短精辟
14 离校退群祝福语简短
15 年末祝福语简短的文案
16 特别的端午祝福语简短
17 别人过大寿祝福语简短
18 祝福语简短古诗词