帮我看一下这个Access, SQL为什么运行不了?说是“number of query values and destination fields are not the same"INSERT INTO Club
VALUES (1,'23 Pitt ST.Melbourne','Super man',2);
我的Club的结构是这样定议的
CREATE TABLE Club
(ClubID INTEGER NOT NULL PRIMARY KEY,
Address CHAR(50),
ClubName CHAR(30),
ClubManagerREgistrationID INTEGER NOT NULL,
Constraint clubmanager foreign key (ClubManagerRegistrationID) references Staff(RegistrationNo)
);
VALUES (1,'23 Pitt ST.Melbourne','Super man',2);
我的Club的结构是这样定议的
CREATE TABLE Club
(ClubID INTEGER NOT NULL PRIMARY KEY,
Address CHAR(50),
ClubName CHAR(30),
ClubManagerREgistrationID INTEGER NOT NULL,
Constraint clubmanager foreign key (ClubManagerRegistrationID) references Staff(RegistrationNo)
);
VALUES ('23 Pitt ST.Melbourne','Super man',2)
这样试试吧,自增字段,不需要手动插入。
select 1,'23 Pitt ST.Melbourne','Super man',2这个可以不?