如何使用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)
以上是 如何使用MyISAM引擎表创建MySQL表? 的全部内容, 来源链接: utcz.com/z/338502.html