InnoDB ইঞ্জিন সহ টেবিল তৈরি করতে ENGINE কমান্ড ব্যবহার করুন। টেবিল তৈরির কোয়েরি:
mysql> CREATE TABLE EmployeeRecords -> ( -> EmpId int, -> EmpName varchar(100), -> EmpAge int, -> EmpSalary float -> ) ENGINE=InnoDB; Query OK, 0 rows affected (0.46 sec)
উপরে ENGINE হিসেবে INNODB সেট করা হয়েছে।
DESC কমান্ড দিয়ে টেবিলের পুরো বিবরণ দেখুন:
mysql> DESC EmployeeRecords;
আউটপুট:
+-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | EmpId | int(11) | YES | | NULL | | | EmpName | varchar(100) | YES | | NULL | | | EmpAge | int(11) | YES | | NULL | | | EmpSalary | float | YES | | NULL | | +-----------+--------------+------+-----+---------+-------+ 4 rows in set (0.05 sec)
টেবিল InnoDB-তে তৈরি হয়েছে কিনা চেক করুন:
mysql> SHOW TABLE STATUS FROM business LIKE 'EmployeeRecords';
আউটপুট (Engine: InnoDB দেখাচ্ছে):
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | 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 | +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ | employeerecords | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-10-22 15:22:01 | NULL | NULL | utf8mb4_unicode_ci | NULL | | | +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+ 1 row in set (0.10 sec)
উপরের আউটপুটে "Engine" কলামে "InnoDB" দেখা যাচ্ছে। MySQL 5.6+ এ InnoDB ডিফল্ট ইঞ্জিন, তাই ENGINE=InnoDB বাদ দিলেও InnoDB-ই হবে।
