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

Are stored procedures precompiled?

928


How do I start mysql from command line?

965


What is general log in mysql?

919


Can we create table in stored procedure?

906


What is blob in mysql?

960


Can you tell the difference between ereg_replace() and eregi_replace()?

992


How do I update a variable in mysql?

888


What is the difference between truncate and delete?

1119


Where is mysql data stored?

837


Which storage engine is best in mysql?

895


What is the difference between truncate and delete in mysql?

1086


What is datadir?

826


Can I use mariadb instead of mysql?

870


What is auto increment in mysql?

915


How to enter boolean values in sql statements?

1072