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

Discussion in 'MySQL' started by tsalexey544, May 16, 2007.

  1. tsalexey544

    tsalexey544 New Member

    Joined:
    Nov 18, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    It is for creating a new table.
     
  3. tsalexey544

    tsalexey544 New Member

    Joined:
    Nov 18, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    0
    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!?!?
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    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.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice