mysql - SQL语法创建表

Question

以下创建表的 SQL 有什么问题？它在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)
)

错误是:

#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

<小时/>

Answer 1

什么是 VARCHAR2？
尝试将其更改为 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)
)