Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   beginner SQL (free) tuts.... Please help (http://www.go4expert.com/forums/beginner-sql-free-tuts-help-t4333/)

tsalexey544 16May2007 14:50

beginner SQL (free) tuts.... Please help
 
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 :confused:

Thank you for your time.

shabbir 16May2007 16:50

Re: beginner SQL (free) tuts.... Please help
 
It is for creating a new table.

tsalexey544 16May2007 16:58

Re: beginner SQL (free) tuts.... Please help
 
I know :p

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 16May2007 17:14

Re: beginner SQL (free) tuts.... Please help
 
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.


All times are GMT +5.5. The time now is 07:59.