jdbc编程问题
sql = "create table SelCour(" + "stuNum char(10),"+ "courNum char(10)," + "grade integer,"
+ "PRIMARY KEY (stuNum,courNum),"
+"FOREIGN KEY (stuNum) REFERENCES Student(stuNum) on delete cascade ,"
+"FOREIGN KEY (courNum) REFERENCES Course(courNum) on delete cascade"
+")";
[Microsoft][ODBC Microsoft Access 驱动程序] CONSTRAINT 子句语法错误。这是怎么回事? --------------------编程问答-------------------- 都说了,是语法错误啊,仔细检查下sql........ --------------------编程问答-------------------- 外键的定义语法格式:
constraint pk_myteacher foreign key(s_myteacher) references tea(t_name)
补充:Java , Java相关