题目要求Values for the semester attribute should be strings in the following format: YYYYsX, where YYYY
stands for the year and X is either “1” or “2”. For example, this session (semester) corresponds to
2009s2.tableCREATE TABLE Offering (
code CHAR(8), -- PK
semester CHAR(20), -- PK, from its own partial key
lecturer CHAR(8), -- FK
roomno CHAR(12), -- FK
day CHAR(3), -- Use the 3 letter abbrev. (UPPER CASE); Nullable
starttime TIME, -- Postgresql have TIME data type.
endtime TIME,
PRIMARY KEY (code, semester),我的写法ALTER TABLE Offering
ALTER COLUMN semester TYPE CHAR(6),
ADD CONSTRAINT ck_semester CHECK (semester like '[0-9][0-9][0-9][0-9][s][1-2]');输入数据 INSERT INTO Offering VALUES ('COMP2011', '2004s1', 's002', 'EE G24',
'Thu', '9:00:00', '10:00:00');
报错 说违反了 ck semester的 constraint
stands for the year and X is either “1” or “2”. For example, this session (semester) corresponds to
2009s2.tableCREATE TABLE Offering (
code CHAR(8), -- PK
semester CHAR(20), -- PK, from its own partial key
lecturer CHAR(8), -- FK
roomno CHAR(12), -- FK
day CHAR(3), -- Use the 3 letter abbrev. (UPPER CASE); Nullable
starttime TIME, -- Postgresql have TIME data type.
endtime TIME,
PRIMARY KEY (code, semester),我的写法ALTER TABLE Offering
ALTER COLUMN semester TYPE CHAR(6),
ADD CONSTRAINT ck_semester CHECK (semester like '[0-9][0-9][0-9][0-9][s][1-2]');输入数据 INSERT INTO Offering VALUES ('COMP2011', '2004s1', 's002', 'EE G24',
'Thu', '9:00:00', '10:00:00');
报错 说违反了 ck semester的 constraint
解决方案 »
- 某个参数不是out类型??
- 求助Mysql执行缓慢的问题
- ERROR: relation "publisher" does not exist 请大家帮忙看看
- mysql怎么启动啊
- 将mysql中的查询结果导出为mdb文件
- mysql问题?
- 郁闷啊郁闷, mysql数据库的或者是php程序的问题,搞不清啊。。。
- mysql 导入数据
- 安装mysql for win2000出错:可安装的虚拟设备驱动程序之dll起始失败。选择“关闭”终止程序
- 求大神帮看条分组排名语句。An error occured in multi-table update。没分了。。。
- 问一下max()的问题
- update语句的问题。
你可以考虑把insert操作写成一个存储过程接口,然后相关数据检查操作在存储过程里面来判断(合适的就插入,不合适的就存储过程输出参数返回错误)
+----------------------+
| "a" regexp '^[0-9]*' |
+----------------------+
| 1 |
+----------------------+
1 row in set (0.00 sec)
你可以在存储过程里面判断