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

What is wronge with my sql script =(?

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
    What is wronge with my sql script :confused:
    I get an error on line 5..... Please help me.
    thanx for your time.

    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;
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    Can you tell what error you are getting? I think you don't need the comma after line 5. ,
     
  3. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    Use bacticks instead of single quotes for field names and table names!

    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;
    
     
  4. tsalexey544

    tsalexey544 New Member

    Joined:
    Nov 18, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    0

    NOW IT IS WORKIG!!!!!! ;)

    I changed it to this:

    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
     

Share This Page