What is wronge with my sql script =(?

Question

What is wronge with my sql script =(
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;

Answer 1

This works:



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))



When you add this:



ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; it doesn't work. You have two: AUTO_INCREMENT=1

You also had spaces in the table name: '*edoobc_*user', where the * is. Hope this helped.

Answer 2

No, they're appropriate yet infrequently an same. sq. is the industry trouble-free question language for relational databases and is particularly same in syntax for each RDBMS in lifestyles. Scripting languages are for springing up purposes and are unique to the DBMS: Oracle has PL/sq., sq. Server has T-sq., etc. on a similar time as there are similarities, the syntax to each is decidedly not same.

Answer 3

what error do u get after executing the code....



i guess change the variable name of email to email1..