Answer Posted / muthuk

Storage Engine - Description
MyISAM Default engine as of MySQL 3.23 with great
performance
MEMORY Hash based, stored in memory, useful for
temporary tables
InnoDB Supports transactions, row-level locking,
and foreign keys
BerkeleyDB Supports transactions and page-level locking
BLACKHOLE /dev/null storage engine (anything you write to
it disappears)
EXAMPLE Example storage engine
ARCHIVE Archive storage engine
CSV CSV storage engine
ndbcluster Clustered, fault-tolerant, memory-based tables
FEDERATED Federated MySQL storage engine
MRG_MYISAM Collection of identical MyISAM tables
ISAM Obsolete storage engine

What is the usage of ENUMs in MySQL?

1178

---

What are triggers in mysql?

973

---

What does mysql_fetch_assoc do?

994

---

What is definer in mysql?

1006

---

What is the current version of mysql?

1016

---

What is the use of i-am-a-dummy flag in mysql?

1053

---

What are the advantages of a procedure?

959

---

What is procedural api?

1042

---

What is the limitation of mysql?

1012

---

How to return query output in html format?

978

---

Explain the architecture models of SQL Server?

2378

---

How to find the unique values if the value in the column is repeated?

1036

---

What is a join in mysql?

954

---

Why myisam is faster than innodb?

991

---

How do I run mysql on a mac?

1009

---