A.CREATEVIEWmyviewASSELECT*FROM产品WHERELEFT(产品号1)="1"
B.CREATEVIEWmyviewASSELECT*FROM产品WHERELIKE("1",产品号)
C.CREATEVIEWmyviewSELECT*FROM产品WHERELEFT(产品号1)="1"
D.CREATEVIEWmyviewSELECT*FROM产品WHERELIKE("1",产品号)