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 are mysql functions?

950

---

Is mysqli faster than mysql?

927

---

What is the maximum size of mysql database?

955

---

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3982

---

What language does mysql use?

911

---

How do I run mysql?

1014

---

What is the difference between myisam dynamic and myisam static in mysql?

1013

---

What is cursor in mysql?

898

---

What's the latest version of mysql?

990

---

Can we store files in mysql?

916

---

How do I select a table in mysql?

936

---

What is difference between mysql_connect and mysql_pconnect?

1043

---

How do I save in mysql?

969

---

How do I make an action query?

937

---

How to update database permissions/privilages.

974

---