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.
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!?!?
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.