I try to dump this in to MySQL…

Code:
CREATE TABLE affiliates (
  affID int(3)  DEFAULT ” NOT NULL auto_increment,
  refid varchar(30)  DEFAULT ” NOT NULL ,
  pass varchar(20)  DEFAULT ” NOT NULL ,
  company varchar(100)  DEFAULT ” NOT NULL ,
  title varchar(5)  DEFAULT ” NOT NULL ,
  firstname varchar(40)  DEFAULT ” NOT NULL ,
  lastname varchar(40)  DEFAULT ” NOT NULL ,
  website varchar(100)  DEFAULT ” NOT NULL ,
  email varchar(100)  DEFAULT ” NOT NULL ,
  payableto varchar(100)  DEFAULT ” NOT NULL ,
  street varchar(100)  DEFAULT ” NOT NULL ,
  town varchar(100)  DEFAULT ” NOT NULL ,
  county varchar(100)  DEFAULT ” NOT NULL ,
  postcode varchar(20)  DEFAULT ” NOT NULL ,
  country varchar(100)  DEFAULT ” NOT NULL ,
  phone varchar(30)  DEFAULT ” NOT NULL ,
  fax varchar(30)  DEFAULT ” NOT NULL ,
  date varchar(40)  DEFAULT ” NOT NULL ,
  PRIMARY KEY (affID)
);
 
INSERT  INTO affiliates  VALUES(’1′,’testAff’,'testAff’,'testAff’,'Mr’,'testAff’,'testAff’,'testAff’,”,’testAff’,'testAff’,'testAff’,'testAff’,'testAff’,'US’,'testAff’,'testAff’,”);
INSERT  INTO affiliates  VALUES(’2′,’testAff1′,’testAff1′,’testAff1′,’Mr’,'testAff’,'testAff’,”,’tester@hotmail.com’,'testAff’,'testAff’,'testAff’,'testAff’,'testAff’,'US’,'testAff’,'testAff’,”);

And it says that the first line, "affID int(3) DEFAULT ” NOT NULL auto_increment,"

is not a valid way to write that string of text, rejecting my entry.

I’m a beginner, and have no way of knowing why this would be so: Perhaps you can tell me?:confused:

30,000 Mb And Unlimited Bandwidth Only $3.75/mo.


Go Daddy $6.95 .com sale 468x60

Powered By: BigInfo.org