Advertisement: Over 100,000 Jobs Worldwide. Click here to find one for you.

FAQs Categories

Client Server Commands

Database Structure

Table Types or Storage Engines

Funtions and Operators

Tricky Select Queries

Speed Up Queries

General Questions

Send This Page to Friend

http://www.kareerlinks.com/jobs/skill/MySQL

Home / Table Types or Storage Engines / Question No: 126

What is default table type of MySQL?

I want to know the current table type or engine being used by my MySQL Server. Also can I know that what is default table type of MySQL?

Answer No: 126

You can check the default table type being used by MySQL to run one of the following queries:

SELECT @@table_type;

or

SHOW VARIABLES LIKE "table_type";

MySQL Server uses MyISAM as its default table type

Comments

Add Comments

Found a bug? Or do you have a better solution for this? Feel free to leave a message:

Related MySQL FAQs to the Above FAQ

How to get storage engines available on MySQL server?

How to change the default storage engine of MySQL?

How to convert a table from one type to another in MySQL?

What is the fastest storage engine in MySQL?

What are transaction-safe tables and not transaction-safe tables in MySQL?