New to mySQL...error just creating table

[jaybytez]

CREATE TABLE EMPLOYEE_TBL
(
EMP_ID VARCHAR2(9) NOT NULL,
LAST_NAME VARCHAR2(15) NOT NULL,
FIRST_NAME VARCHAR2(15) NOT NULL,
MIDDLE_NAME VARCHAR2(15),
ADDRESS VARCHAR2(30) NOT NULL,
CITY VARCHAR2(15) NOT NULL,
STATE CHAR(2) NOT NULL,
ZIP NUMBER(5) NOT NULL,
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);

ERROR 1064: You have an error in your SQL syntax near 'VARCHAR2(9) NOT NUL
L,
LAST_NAME VARCHAR2(15) NOT NULL,
FIRS' at line 3

 

[twiSSt]

Try removing the 2 at the end of VARCHAR

 

[jaybytez]

When I take VARCHAR2 and change it to VARCHAR:

CREATE TABLE EMPLOYEE_TBL
(
EMP_ID VARCHAR(9) NOT NULL,
LAST_NAME VARCHAR(15) NOT NULL,
FIRST_NAME VARCHAR(15) NOT NULL,
MIDDLE_NAME VARCHAR(15),
ADDRESS VARCHAR(30) NOT NULL,
CITY VARCHAR(15) NOT NULL,
STATE CHAR(2) NOT NULL,
ZIP NUMBER(5) NOT NULL,
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);

ERROR 1064: You have an error in your SQL syntax near 'NUMBER(5) NOT NULL,
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KE' at line 10

I am trying to work through examples in Teach Yourself SQL in 24 hours. Is MySQL that hard to learn? Not sure what I am doing wrong?

Thanks!

 

[TonyGroves]

Change NUMBER(5) to MEDIUMINT(5), or, since it's a numeric code (possibly with leading zeroes?), CHAR(5)

-----
ALTER world DROP injustice, ADD peace;