beginner SQL (free) tuts.... Please help

tsalexey544's Avatar, Join Date: Nov 2006
Go4Expert Member
Hi,

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

Code:
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's Avatar, Join Date: Jul 2004
Go4Expert Founder
It is for creating a new table.
tsalexey544's Avatar, Join Date: Nov 2006
Go4Expert Member
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's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.