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

Where is mysql data stored linux?

1018


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1455


What language is used in mysql?

996


How do you backup a database in mysql?

1069


What are the types of queries?

944


What is the use of mysqli_num_rows?

927


Write command to import an mysql file?

1034


How to get the number of rows selected or affected by a sql statement?

921


What is cast in mysql?

903


What is mysql data directory? How to determine the location of the data directory?

941


What is the data type for file in mysql?

987


What are federated tables?

1185


What is difference between mysql mysqli and pdo?

940


How do I disable mysql?

935


In mysql, what is the default storage engine?

1009