SQL create table code

Question

I'm trying to create two MySql tables

CREATE TABLE customer (
     custID int(11) NOT NULL AUTO_INCREMENT,
     custName varchar(50) NOT NULL,
     custPwd varchar(64) NOT NULL,
     custEmail varchar(100) NOT NULL,
     custPhone varchar(10) NOT NULL,
     PRIMARY KEY (custID))

CREATE TABLE request (  
    requestID int(11) NOT NULL AUTO_INCREMENT,
    custID int(11) NOT NULL,    
    requestDate date NOT NULL,
    itemDesc varchar(200) NOT NULL,
    itemWeight int(11) NOT NULL,
    puAdd varchar(100) NOT NULL,
    puSuburb varchar(50) NOT NULL,
    puDate date NOT NULL,
    puTime time NOT NULL,
    dName varchar(50) NOT NULL,
    dAdd varchar(100) NOT NULL,
    dSuburb varchar(50) NOT NULL,
    dState varchar(50) NOT NULL,
    PRIMARY KEY (requestID),
    FOREIGN KEY (custID) REFERENCES customer(CustID))

I keep getting errors saying that there is an error near the first statement. I can't seem to figure out what is actually wrong. Am I missing something really obvious or??

Travis Prescott · Accepted Answer · 2014-08-30 05:26:27Z

2

Assuming you are writing these queries in MySQL Workbench, you need to end each statement with a semicolon. I did this and they ran just fine.

answered Aug 30, 2014 at 5:26

Travis Prescott

4172 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Travis Prescott Over a year ago

You might try something like: "USE {DB_NAME}" and then your table creation statements or "CREATE TABLE {DB_NAME}.{TABLE_NAME}"

Brendon Rother · Accepted Answer · 2014-09-10 01:34:09Z

1

The issue was that there was white space after the open bracket eg. CREATE TABLE customer ("white space"...

Once I deleted the white space everything worked

answered Sep 10, 2014 at 1:34

Brendon Rother

1194 silver badges17 bronze badges

Collectives™ on Stack Overflow

SQL create table code

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related