A.CREATEVIEWmyviewASSELECT*FROM歌手WHERELEFT(歌手号,1)=″1″
B.CREATEVIEWmyviewASSELECT*FROM歌手WHERELIKE(″1″,歌手号)
C.CREATEVIEWmyviewSELECT*FROM歌手WHERELEFT(歌手号,1)=″1″
D.CREATEVIEWmyviewSELECT*FROM歌手WHERELIKE(″1″,歌手号)