SQL syntax creating table

Question

What is the issue with the following SQL to create the table? It's executed in MySQL

CREATE TABLE friend_recommend(
  UID VARCHAR2(10) NOT NULL,
  FID VARCHAR2(10) NOT NULL,
  MID VARCHAR2(10) NOT NULL,
  DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (UID, FID, MID)
)

The error is:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR2(10) NOT NULL, FID VARCHAR2(10) NOT NULL, MID VARCHAR2(10) NOT NUL' at line 2

what error did mysql give you?

Dan D.
– Dan D.

2011-04-30 05:35:34 +00:00
Commented Apr 30, 2011 at 5:35 — Dan D.
– Dan D., Commented Apr 30, 2011 at 5:35

bumperbox · Accepted Answer · 2011-04-30 05:37:31Z

1

whats a VARCHAR2 ?
try changing it to VARCHAR

CREATE TABLE friend_recommend(
  UID VARCHAR(10) NOT NULL,
  FID VARCHAR(10) NOT NULL,
  MID VARCHAR(10) NOT NULL,
  DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (UID, FID, MID)
)

answered Apr 30, 2011 at 5:37

bumperbox

10.2k6 gold badges46 silver badges66 bronze badges

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

1 Comment

ipd Over a year ago

VARCHAR2 is an Oracle datatype, there is no such creature in MySQL.

Collectives™ on Stack Overflow

SQL syntax creating table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related