CODEWITHSUNDEEP
mysql
Yan
Yan

Reputation: 27

ERROR ORA-00907: missing right parenthesis

CREATE TABLE MURID2 (
  ID INT NOT NULL AUTO_INCREMENT,
  IDMURID VARCHAR2(4) NOT NULL,
  NAMA VARCHAR2(30),
  NO_HP NUMBER,
  ALAMAT VARCHAR2(30),
  IDKELAS VARCHAR2(6),
  CONSTRAINT PK_MURID PRIMARY KEY (ID)
);

Why do I have the error ORA-00907: missing right parenthesis?

Upvotes: 0

Views: 342

Answers (1)

reza
reza

Reputation: 1507

first if this is oracle remove AUTO_INCREMENT. this is not suppoerted in oracle.

if this is mysql, replace VARCHAR2 with varchar and

replace following line

NO_HP NUMBER,

with 

NO_HP NUMBER(10),

Upvotes: 1

Related Questions