How to create a MySQL table using MyISAM engine?

To create a MySQL table using the MyISAM engine, you can use the ENGINE command. Let's first create a table using the CREATE command.

mysql>　create　table　StudentRecordWithMyISAM
　　　->　(
　　　->　Id　int,
　　　->　StudentName　varchar(100),
　　　->　StudentAge　int
　　　->　)ENGINE=MyISAM;

Above, we set the engine to 'MyISAM'.

To check how many columns are in the table, use the DESC command.

mysql>　DESC　StudentRecordWithMyISAM;

The following is the output.

+-------------+--------------+------+-----+---------+-------+
|　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)

Check if the table is provided with MyISAM.

mysql>　　SHOW　TABLE　STATUS　FROM　business　LIKE　'StudentRecordWithMyISAM';

The following output clearly indicates that the engine is 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 | 0 |　281474976710655　|　　　　　　　　　1024　| 0 |　　　　　　　　　　　　　　1　|　2018-10-22　15:47:01　|　2018-10-22　15:47:02　| NULL | utf8mb4_unicode_ci | NULL | NULL | NULL | NULL |
+-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+
1　row in set (0.14　sec)

Check if the MyISAM table exists.

mysql> SELECT TABLE_NAME,
　　　-> ENGINE
　　　-> FROM information_schema.TABLES
　　　-> WHERE TABLE_SCHEMA = 'business' and ENGINE = 'MyISAM';

The following is the output.

+-------------------------+--------+
| TABLE_NAME               | ENGINE  |
+-------------------------+--------+
| studentrecordwithmyisam | MyISAM |
+-------------------------+--------+
1　row in set (0.00 sec)