56,679
社区成员
发帖
与我相关
我的任务
分享
create table VEHICLE_TYPE
(make varchar(10) not null,
model varchar(10) not null,
power char(1),
no_pass integer constraint check_pass check (no_pass between 0 and 6),
cap float constraint check_cap check (cap >= 0),
cc integer
constraint check_cc check (cc >= 0),
primary key (make,model));
create table VEHICLE_TYPE(
make varchar(10) not null,
model varchar(10) not null,
power char(1),
no_pass integer check (no_pass between 0 and 6),
cap float check (cap >= 0),
cc integer check (cc >= 0),
primary key (make,model)
);
create table VEHICLE_TYPE(
make varchar(10) not null,
model varchar(10) not null,
power char(1),
no_pass integer,
cap float,
cc integer,
primary key (make,model)
);
mysql> create table OWNS
-> plates varchar(6) not null reference vehicle,
-> purchase_date date,
-> drr char(6),
-> primary key (plates,ownerid));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'plate
s varchar(6) not null reference vehicle,
purchase_date date,
drr char(6),
p' at line 2
mysql>