MySQL #1064 syntax error when creating a table

Question

I have this table, which worked perfectly fine in sql developer, but when I wanted to import it to the MySQL database this is what happend:

CREATE TABLE zem(
ID_zem INTEGER,
nazov VARCHAR2(30), 
kontinent VARCHAR2(30),

CONSTRAINT pk_zem PRIMARY KEY (ID_zem)
);

#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(30), kontinent VARCHAR2(30),

CONSTRAINT pk_zem PRIMARY KEY (ID_zem' at line 3

Please don't tag databases you're not using. I've removed oracle tag. — Kamil Gosciminski
– Kamil Gosciminski, Commented Nov 23, 2016 at 12:03
Well, you cannot use Oracle syntax with MySQL, no matter what client program you use. — Álvaro González
– Álvaro González, Commented Nov 23, 2016 at 12:04
ok then, is there any way I can import my databases with Oracle syntax? Or I need to rewrite them? — nocturne
– nocturne, Commented Nov 23, 2016 at 12:06
varchar2 is not supported by mysql use varchar instead of it... — Happy Coding
– Happy Coding, Commented Nov 23, 2016 at 12:07
No, you obviously cannot. How is MySQL going to know about other engines' data types? What about features that Oracle support and MySQL doesn't, such as check constraints or sequences? — Álvaro González
– Álvaro González, Commented Nov 23, 2016 at 12:12

Danyal Sandeelo · Accepted Answer · 2016-11-23 12:13:12Z

2

change

VARCHAR2

to

VARCHAR

there is no varchar2 in mysql

answered Nov 23, 2016 at 12:13

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

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

Comments

Jan Sršeň · Accepted Answer · 2016-11-23 12:25:26Z

2

There is How to Create tables in MySql, for integer use value like INTEGER(11) -> but is not necessary and MySql does not have data type VARCHAR2, only VARCHAR

CREATE TABLE zem (
ID_zem INTEGER(11) not null,
nazov VARCHAR(30), 
kontinent VARCHAR(30),
PRIMARY KEY (ID_zem)
) ENGINE=INNODB;

edited Nov 23, 2016 at 12:25

answered Nov 23, 2016 at 12:14

Jan Sršeň

1,0733 gold badges23 silver badges48 bronze badges

2 Comments

nocturne Over a year ago

What is ENGINE=INNODB?

Jan Sršeň Over a year ago

Storage engine of MySql DB for your data, Storage Engines

Faizan Younus · Accepted Answer · 2016-11-23 12:07:29Z

1

Hope this helps

CREATE TABLE zem(
ID_zem INT,
nazov VARCHAR(30), 
kontinent VARCHAR(30),
CONSTRAINT pk_zem PRIMARY KEY (ID_zem)
);

answered Nov 23, 2016 at 12:07

Faizan Younus

8031 gold badge9 silver badges14 bronze badges

Collectives™ on Stack Overflow

MySQL #1064 syntax error when creating a table

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related