Go4Expert - What is wronge with my sql script =(?

Go4Expert (http://www.go4expert.com/)

- MySQL (http://www.go4expert.com/forumdisplay.php?f=42)

- - What is wronge with my sql script =(? (http://www.go4expert.com/showthread.php?t=4332)

What is wronge with my sql script =(?

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;

Re: What is wronge with my sql script =(?

Can you tell what error you are getting? I think you don't need the comma after line 5. ,

Re: What is wronge with my sql script =(?

Use bacticks instead of single quotes for field names and table names!

Code: SQL

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;

Re: What is wronge with my sql script =(?

Quote:

Originally Posted by pradeep

Use bacticks instead of single quotes for field names and table names!

Code: SQL

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;

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