Help with SQL code (Resolved)
binarysoul
Member Posts: 993
in Off-Topic
I'm using MySQL 5.1.32 server and when I do this code (taken from a book), it tells me I have a syntax error. Any help?
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)
);
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)
);