mySQL?

[dezkit]

i am new to mysql and im wondering, what does everysingle little word in this code mean

CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

i got this code off youtube by a person posting a tutorial for a mysql/php register/login script.

 

even a link to a manual is very much appreciated.

[rhodesa]

http://dev.mysql.com/doc/refman/5.0/en/create-table.html

 

It explains all the parts well