BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)删除Customer表中姓“刘”和姓“杨”的记录。SQL语句:DELETE FROMCustomer WHERE()
- A、LEFT(Name,1)=‘刘’ORLEFT(Name,1)=‘杨’
- B、NameLIKE‘刘%‘ORNameLIKE杨%‘
- C、NameLIKE‘[刘,杨]%‘
- D、NameLIKE‘[^刘,^杨]%
正确答案:A,B,C
答案解析:有

微信扫一扫手机做题