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';