mysql quick question

[asmith]

CREATE TABLE `registered_members` (

`id` int(4) NOT NULL auto_increment,

`name` varchar(65) NOT NULL default '',

`email` varchar(65) NOT NULL default '',

`password` varchar(65) NOT NULL default '',

`country` varchar(65) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

 

what does the last line means in mysql ?

[roopurt18]

ENGINE=MyISAM

Sets the table's engine to MyISAM.  MySQL supports several engine types, MyISAM is one of them.

 

CHARSET=latin1

Sets the character encoding for the table.  This is important for text comparisons and other things, not really my specialty.

 

AUTO_INCREMENT=1

The table has an auto incrementing field named `id`.  This tells the table to start with the number 1.  The table would have done this anyways, so this is redundant AFAIK.