开发者

mysql create command error

i am running the following mysql command but it gave a strange error

the command is:

CREATE TABLE SATURN.SCBCRSE
(
  SCBCRSE_SUBJ_CODE             VARCHAR2(4) NOT NULL,
  SCBCRSE_CRSE_NUMB             VARCHAR2(5) NOT NULL,
  SCBCRSE_EFF_TERM              VARCHAR2(6),
  SCBCRSE_COLL_CODE             VARCHAR2(2),
  SCBCRSE_DIVS_CODE             VARCHAR2(4  )
)
TABLESPACE DEVELOPMENT
PCTUSED    0
PCTFREE    10
INITRANS   1
MA开发者_高级运维XTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;

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(4) NOT NULL, SCBCRSE_CRSE_NUMB VARCHAR2(5) NOT NULL, ' at line 3

could you please help me

thanks in advance


This is not the CREATE TABLE syntax of MySQL. I believe this is the Oracle's syntax. You may want to check the MySQL syntax here.

Good luck!


It's definitely an Oracle script you using. Oracle supports CHAR, NCHAR, NVARCHAR2 and VARCHAR2 whereas MySQL supports CHAR and VARCHAR. You can probably also remove everything from Tablespace onwards. Tablespace can be used from MySQL 5.1 onwards but it still isn't as straightforward as with Oracle.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜