sql编程练习

① SQL编程题的答案是什么

1.
CREATE TABLE `student` (
`Sno` int(5) NOT NULL,
`Sname` varchar(6) NOT NULL,
`Ssex` varchar(2) NOT NULL,
`Sdept` char(255),
`Sage` int(2) CHECK (value BETWEEN 15 AND 25),
PRIMARY KEY (`Sno`)
)
2.select * from student where Sname like '张%';
3.没有SC表结构
4.insert into student values(95020,"陈冬","男","CS",18)
5.猜的表结构,update set 学分=3 where cno='3';