Re: MySQL data structure

2001-03-21 Thread John Dean
Hi Asaf Maruf Ali wrote: > > Hello. > > I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by >O'Reilly states that for a table named book under a database Test following is the >structure: > Unfortunately the information in this book is so what out of date. May I su

RE: MySQL data structure

2001-03-21 Thread Johnny Withers
ISM tables are "old" structure for mySQL tables they are called ISAM tables.. MYI tables are the new structures for mySQL tables they are called MyISAM This new structure offers better backup/restore features along with better data sanity checking. Not to mention, they are faster. As for backin

Re: MySQL data structure

2001-03-21 Thread Gerald L. Clark
Asaf Maruf Ali wrote: > > Hello. > > I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by >O'Reilly states that for a table named book under a database Test following is the >structure: > > book.ISM > book.ISD and > book. frm > > On my system MySQL 3.23.27 beta the