关于在SQL上编写数据库程序的问题 [英] A question about write a database program on SQL
问题描述
当我编写一个关于SQL数据库的程序来设置数据表时,编译器显示错误''Cpno'之间有一个错误''我找不到程序正确的原因,wrriten是对。请帮我解决这个问题。
(这是节目'CREATE TABLE课程
(Cno CHAR(4)PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLIN,
FOREIGN KEY Cpno REFERENCES课程(Cno)
);
问题是没有名为的数据类型 - SMALLIN
试试这样的东西它应该适合你。
CREATE TABLE课程
(Cno CHAR(4)PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4)REFERENCES课程(Cno),
Ccredit int,
);
试试这个。我想它应该可行。
CREATE TABLE 课程
(Cno CHAR ( 4 ) PRIMARY KEY ,
Cname CHAR ( 40 ),
Cpno CHAR ( 4 ),
Ccredit SMALLINt ,
FOREIGN KEY (Cpno) REFERENCES 课程(Cno)
);
When i wrote a program about database on SQL for setting up a data table ,the compiler showed a error ' there is a mistake between ' Cpno'' I can't find out the reason for the program isright,the wrriten is right. Please help me slove this problem.
(This is the program 'CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4),
Ccredit SMALLIN,
FOREIGN KEY Cpno REFERENCES Course(Cno)
);
The problem is there is no data type named - SMALLIN
Try something like this it should work for you.
CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
Cname CHAR(40),
Cpno CHAR(4) REFERENCES Course(Cno),
Ccredit int,
);
Try this. I guess it should work.
CREATE TABLE Course (Cno CHAR(4) PRIMARY KEY, Cname CHAR(40), Cpno CHAR(4), Ccredit SMALLINt, FOREIGN KEY (Cpno) REFERENCES Course(Cno) );
这篇关于关于在SQL上编写数据库程序的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!