CODEWITHSUNDEEP
mysqlsql
majortom84
majortom84

Reputation: 651

mysql and sql developer

I found how to make sql developer connect to a mysql server and then I made a database. The problem I now have is that I cannot add my tables to it. Is it a syntax problem or am I doing something wrong? I have used (use database;) but now I see and error on some lines. Like in line 352, but it looks fine....

CREATE TABLE acctmanager

(amid VARCHAR2(4) PRIMARY KEY,

amfirst VARCHAR2(12)  NOT NULL,

amlast VARCHAR2(12)  NOT NULL,

amedate DATE DEFAULT SYSDATE,

region CHAR(2) NOT NULL);

enter image description here

Upvotes: 0

Views: 277

Answers (1)

SuRu
SuRu

Reputation: 739

there is no varchar2 in MySQL

replace varchar2 with varchar

Upvotes: 1

Related Questions