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

Explain csv tables.

1071


What is user in mysql?

946


What are the advantages of mysql in comparison to oracle?

1066


How many columns can you create for an index?

995


How many columns can a table have?

976


What is a deterministic function?

1119


What are the disadvantages of mysql?

1123


What do you mean by % and _ in the LIKE statement?

1035


How do I restore a database in mysql workbench?

1069


What is general log in mysql?

1031


How to declare variable in mysql trigger?

1062


What is mysqli_free_result?

950


How to delete a database from mysql server.

1118


How do I view tables in mysql workbench?

973


What are the 3 main types of search queries?

880