donaldunca Posted May 26, 2007 Share Posted May 26, 2007 I want to create table "RESULT". This is my code: CREATE TABLE RESULT( IDstudent INTEGER(4), IDsubject CHAR(6), mark INTEGER) mark is number from 0 to 9, how can I change?maybe mark BETWEEN 0 AND 10 ?My English is not good. Hope you understandThanks! Link to comment Share on other sites More sharing options...
vijay Posted May 29, 2007 Share Posted May 29, 2007 Hi.. Probably I dont think so its possible from mysql except enum('0','1',...'9') or For that you have to provide selection box with value between 0 AND 10 and if you provide text box then you have to validate that one if that text box contain value between 0-10 or not..? Regards,Vijay Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.