Receiving a syntax error for this SQL code

Question

Syntax error:-

CREATE TABLE CUSTOMER (
CustomerID        Int    NOT NULL IDENTITY(1,1) PRIMARY KEY, 
CustomerName      Char(25)                      NOT NULL,
CustomerDeliveryAddress  Char(25)               NOT NULL,                                       
CustomerPhone            Char (10)              NOT NULL,
CustomerBillingAddress   Char(25)               NOT NULL,
CustomerCreditCard       Int                    NOT NULL,
CONSTRAINT  CustomerPK          PRIMARY KEY(CustomerID)
);

Naruto · Accepted Answer · 2016-11-21 17:51:35Z

2

In mysql there is nothing named identity, instead there is AUTO_INCREMENT

CREATE TABLE CUSTOMER (
CustomerID        INT NOT NULL AUTO_INCREMENT  PRIMARY KEY, 
CustomerName      Char(25)                      NOT NULL,
CustomerDeliveryAddress  Char(25)               NOT NULL,                                       
CustomerPhone            Char (10)              NOT NULL,
CustomerBillingAddress   Char(25)               NOT NULL,
CustomerCreditCard       Int                    NOT NULL

);

answered Nov 21, 2016 at 17:51

Naruto

4,3591 gold badge24 silver badges32 bronze badges

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

Comments

Prashant Kumar Singh · Accepted Answer · 2016-11-21 19:00:14Z

1

u have to declare primary key only once

CREATE TABLE CUSTOMER (
CustomerID        INT NOT NULL AUTO_INCREMENT,
CustomerName      Char(25)                      NOT NULL,
CustomerDeliveryAddress  Char(25)               NOT NULL,
CustomerPhone            Char (10)              NOT NULL,
CustomerBillingAddress   Char(25)               NOT NULL,
CustomerCreditCard       Int                    NOT NULL,
PRIMARY KEY(CustomerID));

answered Nov 21, 2016 at 19:00

Prashant Kumar Singh

619 bronze badges

2 Comments

Rhett Claypool Over a year ago

Do I still need this? CONSTRAINT CustomerPK PRIMARY KEY(CustomerID)

Prashant Kumar Singh Over a year ago

their is nothing to use any other thing just write PRIMARY KEY(customerID)@RhettClaypool

Collectives™ on Stack Overflow

Receiving a syntax error for this SQL code

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related