mysql create command error

Question

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
MAXTRANS   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

I don't know what language this is, but it's not mySQL? Edit: According to Google, it's Oracle. — Pekka
– Pekka, Commented Feb 13, 2011 at 19:53

Lachezar Balev · Accepted Answer · 2011-02-13 20:07:19Z

1

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!

edited Feb 13, 2011 at 20:07

answered Feb 13, 2011 at 20:00

Lachezar Balev

12.1k9 gold badges57 silver badges77 bronze badges

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

2 Comments

Omran Over a year ago

is it possible to convert from oracle to myqsl. i.e is there any tool that do that

Lachezar Balev Over a year ago

Yes, there is such a toolkit though I haven't used it. See more infos here: dev.mysql.com/doc/migration-toolkit/en/index.html

Ashraf Abrahams · Accepted Answer · 2011-02-13 20:20:52Z

0

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.

answered Feb 13, 2011 at 20:20

Ashraf Abrahams

7596 silver badges11 bronze badges

Collectives™ on Stack Overflow

mysql create command error

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related