0
Creat table for studen
Sid number(4), sname number(25), sub1_marks number(2)
1 Answer
+ 3
CREATEÂ TABLEÂ `school_db`.`students`Â (
`sid`Â INT(4)Â NOT NULLÂ AUTO_INCREMENTÂ ,Â
`sname`Â VARCHAR(25)Â NOTÂ NULLÂ ,
`sub1_marks`Â INT(2)Â NOTÂ NULLÂ ,Â
PRIMARYÂ KEYÂ (`sid`));
Test on Sqlfiddle:
http://www.sqlfiddle.com/#!9/239940/1