[tsalexey544]

Hi,

I am looking free SQL tuts. I want to understand things like this:

CREATE TABLE ' edoobc_ 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 '',
PRIMARY KEY ('id')
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Cause right now I don;t understand a thing

Thank you for your time.

[shabbir]

It is for creating a new table.

[tsalexey544]

I know

But I don't know how to create it by my own..... I didn't wrote it.... I copied it from some website.....

what does this mean:
unsigned? NOT NULL? auto_increment? or ENGINE=MyISAM!?!?

[shabbir]

unsigned -> Type of Field
NOT NULL -> Field cannot be NULL
auto_increment -> will be an auto increment field
ENGINE=MyISAM -> There are quite a few engines in MySQL and default is MyISAM and so I would suggest don't get into its details right now.