use learnsql;
create TABLE EMPLOYEE_TBL
(EMNOP_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 INTEGER(5) NOT NULL;
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);
show tables;
describe employee_tbl;
describe enployee_pay_tbl;
消息 102,级别 15,状态 1,第 3 行
';' 附近有语法错误。
create TABLE EMPLOYEE_TBL
(EMNOP_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 INTEGER(5) NOT NULL;
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);
show tables;
describe employee_tbl;
describe enployee_pay_tbl;
消息 102,级别 15,状态 1,第 3 行
';' 附近有语法错误。
create TABLE EMPLOYEE_TBL
(
EMNOP_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 INTEGER(5) NOT NULL,
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);
create TABLE EMPLOYEE_TBL
(EMNOP_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 INTEGER(5) NOT NULL;
PHONE CHAR(10),
PAGER CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);
你这个错误好多。
首先(EMNOP_ID VARCHAR(9) NOT NULL;
LAST_NAME VARCHAR(15) NOT NULL;
FIRST_NAME VARCHAR(15) NOT NULL;
这个是用 , 隔开的。
不是 ;
create 完了之后也不要 ;