CREATE TABLE SC (Sno CHAR(5) ,Cno CHAR(4) ,Grade NUMBER,PRIMARY KEY(Sno,Cno), CONSTRAINT fk_sc_student FOREIGN KEY (sno) REFERENCES Student(Sno), CONSTRAINT fk_sc_course FOREIGN KEY (cno) REFERENCES Course(Cno))/ 就可以正确建表了。
Oracle 添加数据怎么总是缺失右括号?create table Category(categoryId int primary key AUTO_INCREMENT,---报错name varchar(128),description varchar(512) );缺失右括号 create table Category(categoryId int(10) primary key AUTO_INCREMENT,name varchar(128),description...
您的日期条件不对。需要一个单引号。select STATION, LOCAL_TIME,GLOBAL_TIME,V1,OCC1,SP1,V1/SP1 as DENSITY1 from ORIGINAL_DETECTOR_DATA where STATION in(717486) and DATES in ('2005-08-06 00:00:00')
https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB ...