Jump to content

newbie's question


donaldunca

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...