I know that when creating table,the default table storage engine is MyISAM in MySQL. But i know it not very clearly. What is MyISAM? and when should I use InnoDB? Could anyone tell me more about them?

Ricky,

In my experience and how I understand it:
MyISAM - you use it when most of your applications
or datas use in this table are text or VACHAR data types.
One advantage is it is fast speed in text searches.

InnoDB - you use this Engine table types when
your datas or when you derive datas to this table
is calculated. Use this when your calculation to store
the result to these datas uses memory. Like a memory function
in a calculator.

Also, the new features of the current version of MySQL currently 5.0 will only apply to InnoDB table engine. This includes Store Procedures, Triggers, Sub-Queries, Temporary Tables and more.

i hope this helps,
John

yes ,i want know it too.
www.codeuu.com