Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the difference between MyISAM Static and MyISAM
Dynamic?

Answer Posted / amith

In MyISAM static all the fields have fixed width. The
Dynamic MyISAM table would include fields such as TEXT,
BLOB, etc. to accommodate the data types with various
lengths.

MyISAM Static would be easier to restore in case of
corruption, since even though you might lose some data, you
know exactly where to look for the beginning of the next
record.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is data stored in mysql?

868


Is mysql running ubuntu?

913


Which datatype is used for email in mysql?

909


What is mysql sleep process?

938


What is general log in mysql?

911


What is blob storage?

928


How do I start mysql database?

907


I want to start and stop mysql on windows? How do I do that?

1003


What are date and time data types?

928


Is sqlite faster than mysql?

872


Can mysql store files?

866


What are the differences between char and varchar?

1040


how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2175


Can I use mariadb instead of mysql?

865


What are the differences between innodb and myisam engines?

919