CREATE TABLE school (
student_id INT PRIMARY KEY ,
student_name VARCHAR (30) ,
student_major VARCHAR (35) ,
student_final_grade DECIMAL (4,2)
);
DESCRIBE school;
INSERT INTO school VALUES (101, 'Ali', 'computer science', 50.00);
i am getting this error after running this , any advice would be appreciated
ERROR : out of range value for column 'student_final_grade' at row 1
errOr code : er_DATA_OUT_OF_RANGE
i am using popsql
i tried with different value and still its not working and i expect to insert the values above
New contributor
COMPUTER SARAY is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.