MySQL修改属性问题
CREATE TABLE READ_BY4
( CallNumber char(8) NOT NULL,
LibId char(6) NOT NULL,
TimesRead integer(2),
PRIMARY KEY (CallNumber,LibId),
FOREIGN KEY (CallNumber) REFERENCES TITLE4(CallNumber),
FOREIGN KEY (LibId) REFERENCES MEMBER4(LibId)
);
我现在要写个修改语句将TimesRead属性值设置成不能为负数,该怎么写?(要写在创建该表语句的外面)
------解决方案--------------------ALTER TABLE READ_BY4 CHANGE TimeRead TimeRead INT(2) UNSIGNED;