CODEWITHSUNDEEP
mysql
Thompson
Thompson

Reputation: 2000

What are the different tables present in MySQL?

What are the different tables present in MySQL, and which type of table is generated when we are creating a table in the following syntax:  create table employee (eno int(2),ename varchar(10)) ?

One of my senior asked me, I am not able to find it out.

Upvotes: 0

Views: 2864

Answers (4)

Gagan Lamba
Gagan Lamba

Reputation: 11

its myisam is default tabel engine where tables insert by this query and

  • MyISAM Startup Options
  • The InnoDB Storage Engine
  • The MERGE Storage Engine
  • The MEMORY (HEAP) Storage Engine
  • The BDB (BerkeleyDB) Storage Engine
  • The EXAMPLE Storage Engine
  • The FEDERATED Storage Engine
  • The ARCHIVE Storage Engine
  • The CSV Storage Engine
  • The BLACKHOLE Storage Engine

Upvotes: 0

user1285324
user1285324

Reputation:

This is a basic kind of question a beginr ask, all answers are right till now, for further knowledge read this artical of dev.mysql

http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html

Upvotes: 1

user1191247
user1191247

Reputation: 12998

SHOW VARIABLES LIKE 'storage_engine';

will return the current default storage engine.

Upvotes: 1

Eric J.
Eric J.

Reputation: 150108

Starting with MySQL 5.5, InnoDB is the default storage engine. Prior to that, it was My ISAM.

http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html

If you do not further specify the type of storage engine you want, you will get the default for the version of MySQL you are running.

Upvotes: 2

Related Questions