1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,276
    Likes Received:
    364
    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,276
    Likes Received:
    364
    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