MySQL-এ MyISAM ইঞ্জিন সহ টেবিল তৈরি করা

MySQL টেবিল MyISAM ইঞ্জিনের সাথে তৈরি করতে ENGINE কমান্ড ব্যবহার করা হয়। প্রথমে CREATE কমান্ড ব্যবহার করে টেবিল তৈরি করুন।

mysql> CREATE TABLE StudentRecordWithMyISAM
-> (
-> Id int,
-> StudentName varchar(100),
-> StudentAge int
-> ) ENGINE=MyISAM;
Query OK, 0 rows affected (0.26 sec)

উপরে ENGINE হিসেবে "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';

আউটপুট (Engine: 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)

information_schema দিয়ে চেক করুন:

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)