create table parkstaff
(number int not null primary key,
name char(8),
sex char(2),
phone char(20),
job char(8))
insert parkstaff(number,name,sex,phone,job)
values(001,"张三","男","12345678901","员工")
请问为什么会显示列名无效呢?
(number int not null primary key,
name char(8),
sex char(2),
phone char(20),
job char(8))
insert parkstaff(number,name,sex,phone,job)
values(001,"张三","男","12345678901","员工")
请问为什么会显示列名无效呢?
CREATE TABLE parkstaff
(
number INT NOT NULL PRIMARY KEY,
NAME CHAR(8),
sex CHAR(2),
phone CHAR(20),
JOB CHAR(8)
)
--值中的双引号改成单引号
INSERT parkstaff
(
number,
NAME,
sex,
phone,
JOB
)
VALUES
(
001,
'张三',
'男',
'12345678901',
'员工'
)
values(001,'张三','男','12345678901','员工')