Tutorialspoint

1 Answer
Smita Kapse

The variable table_type doesn’t work since this variable is deprecated as of MySQL 5.5.3. Use default_storage_engine instead. Following is the syntax −

SET default_storage_engine = yourTableEngine;

The table engine name may be InnoDB or MyISAM. Here, we will set engine type to MyISAM −

mysql> SET default_storage_engine=MyISAM;
Query OK, 0 rows affected (0.00 sec)

Let us create a table.

mysql> create table DemoTable
   (
   Id int NOT NULL AUTO_INCREMENT PRIMARY KEY
   );
Query OK, 0 rows affected (0.40 sec)

Now check the engine type of above table −

mysql> SHOW TABLE STATUS WHERE Name = 'DemoTable';

This will produce the following output −

+--------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
| 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 |
+--------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
| DemoTable    | MyISAM | 10      | Fixed      | 0    | 0              | 0           | 1970324836974591 | 1024         | 0        | 1               | 2019-05-01 22:15:03 | 2019-05-01 22:15:03 | NULL | utf8_unicode_ci | NULL | | |
+--------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
1 row in set (0.34 sec)

Look at the above sample output, the engine type is MyISAM.

NOTE − In MySQL version 8.0.12, the default storage is InnoDB. Here we have changed the storage engine to MyISAM for current session only.

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.